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