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


--
OlYeller21
------------------------------------------------------------------------
OlYeller21's Profile: http://www.excelforum.com/member.php...o&userid=36309
View this thread: http://www.excelforum.com/showthread...hreadid=562443

Check out "Conditional Formatting" in XL Help.

In article <(E-Mail Removed)>,
OlYeller21 <(E-Mail Removed)>
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 %.


--
patele
------------------------------------------------------------------------
patele's Profile: http://www.excelforum.com/member.php...o&userid=35849
View this thread: http://www.excelforum.com/showthread...hreadid=562443

Hey, thank you, that worked perfectly.
Zac

--
OlYeller2
-----------------------------------------------------------------------
OlYeller21's Profile: http://www.excelforum.com/member.php...fo&userid=3630
View this thread: http://www.excelforum.com/showthread.php?threadid=56244