When we use microsoft Excel ( I use excel 2007) we can get value from other sheet in the same file or from other file, here I give example from the same file but difference sheet
1. I have sheet “ScoreScience” and “ScoreMath”
2. Next I want to create new sheet that get value from both score sheet to get average value. Fill your formula like this [SheetName!CellPosition]:
Hope it well help you.
You can use Conditional Formatting in Excel 2007, and here the steps to do :
1. First create your data in Excel sheet
2. Block data that need to filtering by color (cell function with conditional formatting)
3. After that click menu – Conditional Formatting – New Rule
4. Fill new formatting, in this case i choose format only cell that contain less than value 8 ( so value than less than 8 will get red color) 
5. After that click button Format, and click on tab Fill and fill it with red color 
6. And here the result : 
Ok you can try this step, and have a nice excel explorer.
We can create combobox value in the cell, we can try this as like this :
Open your Excel 2007, and create this value
Optional value will hide later.
Go to menu Data – Data Validation 
And select your list range 
And you will get this result : 
Hope this step will help you to create combobox – dropdown value in excel cell.
Link File for this sample
Ingatlah hukum dasar ini, dalam kehidupanmu Barang siapa yang menanam, dia pula yang akan menuai
