If, then...

[Jonas Weebler]

I have a simple formula in a cell: =SUM(E29+G28-F29)

Is there a way to change the color of the cell when the value in the
cell goes above or below zero with an "If / Then" statement? Thank
you in advance.

 

[Ray at]

Check out conditional formatting from the format menu for your cell.

Ray at work

 

[Bob Kilmer]

or SUM(E29,G28,-F29), if you prefer.