So, I know how to conditional format a cell based on whether the date entered is past today's date by 3 days.
Using the 'USE A FORMULA TO DETERMINE WHICH CELLS TO FORMAT' =TODAY()-H15>3
What I would like is for the conditional format not to apply once the actual date has been entered in the adjacent cell.
Bookmarks