Conditional formatting

[Guest]

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

 

[Guest]

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:

 

[Carim]

Hello Pascale,

Something along these lines ...
Choose Formula Is
and add following formula :

=(TODAY()-B2)>=7

HTH
Cheers
Carim

 

[Guest]

Hello
Excellent. THANK YOU. It works!!
so if I need for 2 months, what would I type =today()-60 ???
Pascale

 

[Guest]

Hello Carim
THANK YOU VERY MUCH. It works!!!
So what would I put if it were for 2 months

=(TODAY()-B2)>=60 ???

 

[Guest]

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

 

[Carim]

Hello Pascale,


I am surprised ... copying "conditionnally formatted" and clearing
cells contents should not format the empty cell, since the condition is
not met ...

If you still have this problem, could you explain a bit further ...

A +

Carim

 

[Guest]

I know this post is over a year old but I found it tremendously helpful in
formatting a project coming up due and then when it was overdue. Thanks!