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?
O
, you want the value in columnN
to revert to normal formatting?