I have a range of dates in A1:A100. I would like to set up conditional formatting in the cell to change to light red fill with dark text if the date is 3 days prior to that date in the cell.


So, if the date is 4/17/2020, I want it to conditionally format the date/cell on 4/14/2020, so I know that it's due in 3 days.



Your help is greatly appreciated.