You need at least 2 rules. You could set one format as the default (say
red). Then

CF1: Formula is =(A1-TODAY())<=3
Format1: <green

CF2: Formula is =(A1-TODAY())<=7
Format2: <orange

or you could leave the cell(s) formatted as general and add the third CF:

CF3: Formula is =ISNUMBER(A1)
Format3: <red

In article
,
Roger wrote:

Hi
I'm using Excel 2007 and would like to know how to conditionally
format dates so the color changes as per:
Green - the last 3 days
Orange - 4 to 7 days old
Red - older than 7 days

Is there a single formula that can do this under the conditional
formatting or do I need to do 3 rules?

Cheers