You can use Conditional Formatting from the Format menu to do
this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"bre" wrote in
message ...

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