Coloring a Cell

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

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

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 %.

Hey, thank you, that worked perfectly.
Zach