How to use Excel Conditional Formatting to highlight past dates

Excel has very powerful feature called conditional formatting. In this post I will demonstrate how to use the feature to automatically highlight past dates in different way than future dates.

  • I use TODAY()-function to get current date
  • I set conditional formatting so that when the value of the cell is less than TODAY(), it will be formatted

Following video demonstrates this:

Leave a Reply

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

*