Learn how to automatically highlight overdue dates in Excel using Conditional Formatting! Whether you’re managing invoices, tracking tasks, or keeping tabs on deadlines, this technique will help you quickly and easily identify overdue items at a glance.
The screenshot below is from an Excel file that I use to track the training that I deliver. Using a simple Conditional Formatting rule, the cell containing the Invoice Number will be highlighted in red if the Delivery Date on that row is more than 30 days ago (for the purpose of the demo today’s date is 2nd December 2024).
At the moment the training that I delivered on 6th/7th November is not coloured red because it is within the 30 day period. However as soon as there are more than 30 days between those dates and the current date, the cell background will automatically change to red.
Formulas used in the video:
=$F$1 - B2 > 30
=TODAY() - B2 > 30
Download a copy of the file(s) used in this video: https://share.zight.com/yAuglAXZ