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