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: