Coloring cell text based on value

Z

Zilbandy

I have a cell with the following formula:
=SUM(E11:E49)

What I would like to do is have the result display in red if the the
value is over 2000 and to display in blue if the value is less than or
equal to 2000.

Thanks for the help. :)
 
T

Tom

Zilbandy,

I would first color the cell blue. Then, with the cell in question
selected, go to the Format menu choice and select Conditional
Formatting. Choose "Cell Value Is", "greater than", and type 2000.
Then hit the "Format..." button and change the Color to red. Hit OK.
Hit OK. Done.

--Tom.
 
Z

Zilbandy

I would first color the cell blue. Then, with the cell in question
selected, go to the Format menu choice and select Conditional
Formatting. Choose "Cell Value Is", "greater than", and type 2000.
Then hit the "Format..." button and change the Color to red. Hit OK.
Hit OK. Done.
Click to expand...

Worked like a charm. Thanks. :)
 
Top