Tuesday, July 25, 2017

Conditional formatting in Excel according to today's date

I have an Excel file that links to some documents, certificates and such, which are valid for a year. For example, since Feb 20, 2014 until Feb 20, 2015.


To the right, I have a column in which are the dates of expiry, and next to it a column that is a month earlier - when I should start thinking about contacting the 3rd party to send us the new certificate for the following year.


Is there a way to make a date cell in excel be conditionally formatted (for example red background with while letters) depending on the date today?
For example, in that second column, all dates from Jan 20, 2015 until todays should be coloured red.


Is that possible and how would one go about that?

No comments:

Post a Comment

hard drive - Leaving bad sectors in unformatted partition?

Laptop was acting really weird, and copy and seek times were really slow, so I decided to scan the hard drive surface. I have a couple hundr...