Use conditional formatting.

See http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"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