Hi,
I have a row of set dates as shown in the excel, column A.
I am trying to do a conditional formatting where it changes cell colour and font colour.
My aim is to; To change colour cell if the date is within 90days from the date shown in column A. And if the cell is blank, do not change colour should stay as default.
Excel:
- Column A = Set of dates
- Column C = Where there are commentary, the cell in column A needs to change the date
Thanks again!
Bookmarks