Coloring cell text based on value

[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.

 

[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.

 

[Guest]

Hi Zilbandy

Highlight your cells, go format-conditional formating and follow your nose
from there.

Glenton
www.leviqqio.com

 

[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.

Worked like a charm. Thanks.