How to highlight dates that are older than 70 days using Excel’s Conditional Formatting

Following video demonstrates how to use Excel’s conditional formatting to highlight dates that are older than 70 days. The formula takes into account that empty cells won’t be highlighted. Following formula in D1’s Conditional Formatting does the trick:

=AND(D1<>“”;DAYS360(D1;TODAY())>=70)

Copy the formula to all cells in column D.

Here is a video demonstrating this:

Leave a Reply

Your email address will not be published. Required fields are marked *

*