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

I guess you want to compare the date in the cell with today's date...
If yes, then use the formula
=(Today()-A1) 7 for GREEN
=AND(=(Today()-A1) < 7, =(Today()-A1) =0) for YELLOW
=(A1-Today()) 0 for RED

The above is for showing you how to do it. Verify the conditions to see they
match with what you want. Also choose the option to STOP if the condition is
true... In Excel 2007 (Excel 2003 stops after the first match) you can
evaluate all conditions...

"Cos marchy" wrote:

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

Hi,

In 2007:
1. Highlight all the cells on the rows you want formatted
2. Choose Home, Conditional Formatting, New Rule
3. Choose Use a formula to determine which cell to format
4. In the Format values where this formula is true enter the following
formula:
=A1<TODAY()-7
5. Click the Format button and choose a format.
6. Click OK twice
7. New Rule
8. Choose Use a formula to determine which cell to format
9. In the Format values where this formula is true enter the following
formula:
=A1<TODAY()
10. Click the Format button and choose a format.
11. Click OK tree times.

and so on
=A1=TODAY()
red
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Cos marchy" wrote:

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