Check out "Conditional Formatting" in XL Help.
In article <OlYeller21.2b57w2_1153229404.8151@excelforum-nospam.com>,
OlYeller21 <OlYeller21.2b57w2_1153229404.8151@excelforum-nospam.com>
wrote:
> Is there any way to make a cell turn a different color when the value in
> it is something? I have a bunch of scores being calculated and I want
> anything lowed than 80% to be tunred yellow and anything below 60% to
> be turned red. I have some programming knowledge and I'm willing to
> learn. Thanks
> Zach
patele - 18 Jul 2006 15:24 GMT
Use conditional formatting.
Go to Format>Conditional Formatting:
First Block: Select Cell Value Is
Second Block: Select between
Third Block: enter 0
Forth Block: enter 0.59
Select Format
Select Patterns and click on Red
Click on OK
Click on Add>> at the bottom
Follow the above except in the Third Block this time enter 0.6 and in
the Forth Block enter 0.79
Select Format
Select Patterns and click on Yellow
Click on OK
Click on OK again.
Make sure the cells you're formatting are formatted as %.

Signature
patele
OlYeller21 - 19 Jul 2006 14:18 GMT
Hey, thank you, that worked perfectly.
Zac