|Please do not double post your request (also posted in Database section)|
as it make it difficult to keep track of your question and answers.
You did not specify which version of Excel your using, so this is for 2003:
Conditional Formatting 2003
1) – Select your cell or range of cells, IE A1 thru B10
On the Menu Bar:
2) - Format
3) - Conditional Formatting
4) – Change “Cell Value is” to “Formula Is”
5) – Enter the formula:
Sub Menu Format :
6) - Patterns
7) - Select a pretty color
8) - Press OK
See how that works for you.