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
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?