Conditional formatting

P

Pascale

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
 
F

Fingerjob

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:
 
C

Carim

Hello Pascale,

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

=(TODAY()-B2)>=7

HTH
Cheers
Carim
 
P

Pascale

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

Pascale

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

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

Pascale

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
 
C

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
 
C

CFrank

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!
 
Top