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?

  • 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


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.