Just a general point - colouring cell backgrounds can make the content
unreadable, expecially if printed in monochrome (ie greyscale).
Changing the colour for the text can be more useful, using a custom format
as suggested perhaps. However, this does not lend itself to skim reading for
things (eg to quickly spot the negatives), nor is it any use for people with
some forms of colour blindness or again for monochrome printing. A couple of
options to help with this:
- use a conditional format to make one of the kinds of text bold as well (eg
the negative values)
- use a cond. format to add a cell border.
- include 'standout' text characters in the custom format to make cells
stand out eg [Green]* $#,##0_);[Red]"LOSS! "($#,##0)
--
Adam Vero
MCP, MOS Master, MLSS, CWNA
http://veroblog.wordpress.com
http://www.meteorit.co.uk


"Alex Vega" wrote:

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