Hi Friends,

COuld you please suggest a rules for conditional formatting cells with a date range- 05-May-2015

If given date is 14 days before today- highlight green
If given date is 5 days before today-highlight yellow
If given date is today or past today-highlight red

Example - Today is 06-May-2015

in cell A1 date given is 22-April-2015 , green
in cell A2 given date is 01-May-2015, yellow
in cell A3 given date is 06-May-2015, red
in cell A4 given date is 08-May-2015, red

thanks in advance