Mar 02 2021 12:25 PM
Mar 02 2021 12:52 PM
Select the dates in column D. I'll assume that D2 is the active cell in the selection.
Remove the current conditional formatting rule(s).
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Usea formula to determine wich cells to format'.
Enter the formula
Specify the desired formatting in the Font and Fill tabs.
Click OK, then click OK again.