Or use a custom number format...

[Green]$#,##0_);[Red]($#,##0)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Alex Vega"
wrote in message
How do I add a formula to make a cell color (red for negative, green for
positive) reflect a positive or negative total when adding/subtracting 2
different cells.
i.e. cell A43-A49, total sits in cell E49. If total is negative, then cell
E49 turns red; if positive, cell A49 turns green.
-A43 is a total of 40 previous cells added while A49 is the total of 4
previous cells added.
Thanks.
Alex