How to Use Conditional Formatting Based on Date in Microsoft Excel
Conditional formatting is a terrific feature for automatically applying highlights or font formats to cells. If you have an Excel spreadsheet that contains dates, you can use this feature to make certain dates stand out and easy to spot.
Source: howtogeek.com