Hello all,
I would like to add some conditional formatting on dates but I am unsure on
the formula.

What I would like todo is color code a cell containing a date such that it
identifies how late it is. For example:
More than a week before the date is green
Between the week before the date right up to the date is yellow
After the date is red.

I am using Excel 2007 and can see that there is some quite snazzy
conditional formatting in this version but I am stuck with the formula (or
however else) you actually apply this.

--
Any help is appreciated

Thanks