# Making A Cell Change Background Color Based On If Positive Or Negative Sum Total

Jul 3, 2006I have excel sheet with colored cells.

Positive cash flow cells all have green background,

Negative cash flow cells, all have red background.

I calculate all the "sub- total" columns into one "total sum" cell. Based on this "total sum" I want the cell background to be red if the total sum is negative, or green if total sum is positive. How do I make the cell change to the proper background color based on whether it's a negative or postive total sum?