color text base of value of the formula

[Joe]

Hi,

Is there a way to make the results of a formula in a cell a certain color
(red, green... etc) base on the results of the forumla (below zero its red,
above, its green). And if its above 50 its dark green? below
-50 its pink?

 

[Rajan Lengde]

Use options in Menu
format/conditional fomrting

 

[Joe]

Can you what do you mean?
I can't find what you are saying

 

[L. Howard Kittle]

Hi Joe,

Conditional formatting allows three conditions and you want four.

Try this,

Format the cell to light green which will be the 0 + color.
Condition 1 Cell value Greater than 50
Condition 2 Cell value Less than -50
Condition 3 Cell value Less than 0

I believe this gets you there.

HTH
Regards,
Howard

 

[Joe]

I can find the command or menu item you mentioned.

Where is it?