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?