Conditional Formatting
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
|