- 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:
Tuesday 29 January 2013
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.
Following video demonstrates this:
Following video demonstrates this:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment