If, then...

J

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.
 
R

Ray at

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

Ray at work
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
Copy addition formula of non-consecutive horizontal cells 2
Automatically populate value of cell dependent on adajecent cell 3
Copying Solver results of each iteration to a given location in a workbook 1
Newbie Help - IF Yes No Function 0
how can I copy/paste a formula that skips 27 rows? 0
Filling a reference series in alphabetical order, not numerical 1
Running a macro based on cell value that is updated by formula 2

Top