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

Hi,

Am Wed, 6 May 2015 05:39:24 +0100 schrieb Excel Dumbo:

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

Condition1: =A1<=TODAY()-14 = green
Condition2: =A1<=TODAY()-5 = yellow
Condition3: =A1=TODAY() = red

Note that the conditions has to be in this order.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional