Ecel Dumbo
Member
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
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