Making and If Statement using a date

Copper Contributor

I would like cell to highlight green if the cell next it is older than last week or a specific date.  


1 Reply


A conditional formatting formula like below will check is the week number of a date entered in A1 is less than the current week number minus 1 or on a particular date. In the formula I hard-coded September 1, 2022, but you could replace that by a reference to a cell that contains "a specific date".



In Excel for the web, it looks like this:

Screenshot 2022-09-05 at 06.13.39.png

Screenshot 2022-09-05 at 06.13.12.png