0

I have a spreadsheet which indicates when dates listed in Column N are coming up within the next 30 days (red, italic text) or are overdue (red, italic text and yellow cell fill).

I have achieved this by conditional formatting based on cell value with the formulas =NOW()+30 and =NOW().

The problem I am having is that when I enter a date or text into column O in the corresponding row, I want the conditional formatting to revert back to no format.

How can I accomplish this?

1
  • 2
    What are you saying? That when you enter a value in column O, you want the value in column N to revert to normal formatting? Feb 26, 2013 at 2:17

1 Answer 1

0

I would use the an IF statement in the formula to check column O.

=IF(ISBLANK($O1), [your formula]," ")

In essence, this checks if O is blank. If so, it runs your formula. If not, it skips it.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .