Using Excel & IF value for date and deposit

Microsoft Office excel 2007 home & stude...
August 16, 2010 at 12:19:34
Specs: Macintosh
I have a spreadsheet that is to handle cash flow....

The question is I need a cell to show a negative figure until a cell has a date in it.
Basically cell O2 has a sum in it which is F2 - I2 + N2.
"If P2 is empty, then O2 should show as a negative, until P2 has a date in it."

Can someone please send me a formula to do this, as a negative and preferably the cell in red until P2 is has data.

Thank you very much, this is taking too much of my time and help is greatly received,


See More: Using Excel & IF value for date and deposit

Report •

August 16, 2010 at 13:05:01
Here's one way:

In cell O2 enter the formula:


To get the cell Red use Conditional Formatting

1) Select your cells - O2

2) On the ribbon click Conditional Formatting

3) Click on New Rules, it’s near the bottom of the dialog box.

4) Click Use Formula to determine which cells to format.

5) Enter the formula: =IF(P2="",TRUE,FALSE)

6) Click on the Format button

7) Select the Fill Tab

8) Select a pretty color

9) Click OK

10) Click OK


Report •

August 16, 2010 at 13:24:03
You are a genius, thank you so very much for your help!!!!!!!!!!!

Report •

August 16, 2010 at 13:46:30
Glad I could help.


Report •

Related Solutions

August 16, 2010 at 14:17:30
Sorry, another question with regards to this now. Eg. Column A now has both + & - amounts in them. We would like to do a total sum that collates just the positive amounts, so they are not subtracting from the running total?
Does that make sense?
Thank you Ian

Report •

August 16, 2010 at 14:26:59
Does that make sense?


Post as a separate question with a bit more detail and/or examples of before & after.


Report •

Ask Question