Sorry if this is wrong forum, not sure where it should go.

Is there a way to change a cell's color based on it's contents? For
instance, if a cell contains zero, I would like it to be red. If
greater than 100, I want it blue. Anything in between 0 and 100, no
color change is required. Thanks.


--
bre
------------------------------------------------------------------------
bre's Profile: http://www.excelforum.com/member.php...o&userid=20765
View this thread: http://www.excelforum.com/showthread...hreadid=483708