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