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" wrote in message
...
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?