change cell color based on cell value

C

caerdwyn

Is there a way I can change the color of a cell based on the value
entered into it?

Basically I want to color a cell RED with a value less than, say, 2.

Any ideas?

Thanks!
 
G

George

Is there a way I can change the color of a cell based on the value
entered into it?

Basically I want to color a cell RED with a value less than, say, 2.

Any ideas?

Thanks!
Click to expand...
As Ron and jiwolf mentioned conditional formatting does work and can do
a lot more like borders, background etc

For something as basic as one simple color the old method of number
formatting still works
Check out how negative numbers are red when you use currency format

There are only some basic colors to choose from
[Black], [Blue], [Cyan], [Green], [Magenta], [Red], [White], [Yellow]

and you can only specify 3 (maybe 4 zones) from memory
This example from the help file is self explanatory
[Red][<=100];[Blue][>100]
RED for less than or equal to 100 and BLUE for greater than 100

This should work for you under cell number formatting custom
[Red][<=2];[Black]

Hope this helps
George
 
Top