Hi,

I have a spreadsheet which contains a list of dates when training was completed and the date each course expires. The expiry is shown as a number od days (eg 3 years is 365*3)

What I am trying to do is apply Conditional Formatting whereby the cell will turn red when the date shown as completed has exceeded the renewal period. That is, with a completed date of 19 August 2013 and an expiry date of +1095 days (3 years), how do I get the cell to show red when the expiry date is greater than 19 August 2013 + 1095 days (3 years)?

I have been going around in circles with this one and I will be grateful for your help.

Thanks

Stuart