Excel 2007 : Change collor if date today is < given date -30days

Closed
Geoff84 Posts 2 Registration date Thursday January 15, 2015 Status Member Last seen January 15, 2015 - Jan 15, 2015 at 05:19 AM
Dears,

Does anyone know how I can highlight a date in red or green when a given date passes the last 30 days cf date today?

ex 1
Today : 15/01/2015
Given date : 1/02/2015
--> date is still OK as still 1,5 months to go --> date in green

ex 2
Today : 15/01/2015
Given date : 31/01/2015
--> last 30 days have started, only 15 days to go before the 'end' --> date in red

With the Conditional Format i cannot do it and with an IF i cannot find it :-(

Thanks if someone can help me out here

Kind regards
Geoffrey