Hi all,
Please can someone enlighten me on the code required to do the following:
I have an opening date and an install date which is 140 days before the opening, I need to set up a conditional format on all date cells to go red if that day passes against the present day.
e.g.
I need the opening date to go red if today is the install day
I need the install date to go red if today is now within 140 days of the opening date.
example1.xlsx
Please find example attached
Thanks
Bookmarks