making a cell change background color based on if positive or negative sum total
I 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?
(i.e. anything from .01 and up would be green backround color, anything from zero or less than zero, would be red background color)
Video Tutorials / Excel Dashboards Reports