If, then...
 

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.

If, then...
 

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

Ray at work

"Jonas Weebler" wrote in message
om...
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.

If, then...
 

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

--
Bob Kilmer


"Tom Ogilvy" wrote in message
...
sum is redundant, just do

=E29+G28-F29

--
Regards,
Tom Ogilvy


Jonas Weebler wrote in message
om...
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.