|
Posted to microsoft.public.excel.newusers
|
|
|
Changing a cell color to reflect positive or negative total
Thank you for responding.
Alex
"Jim Cone" wrote:
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
|