Coloring a Cell

O

OlYeller21

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
 
P

patele

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