Sorry to trouble you AGAIN but when I copied this formula to some empty
cells, they all turn red. any suggestion to avoid this??
Many thanks
Pascale

"Fingerjob" wrote:

Hi,

Choose "lesser then" and type this formula " =today()-7 " for a week

One week later the cell should turn red or whatever the colour you choose.

Petter

Pascale skrev:

Hello
In A1, I have the text "Dates" and in B2:30, I will have a date per cell.
Can I use conditional formatting for Excel to colour B2 when the date entered
is 1 week or 1 month old. Example: I have entered in B2 the date 14/08/06,
how can conditional formatting kicks in by colouring the cell red
automatically one week later on 21/08/06.

Many thanks