Conditional formatting
 

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

Conditional formatting
 

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

Conditional formatting
 

Hello Pascale,

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

=(TODAY()-B2)=7

HTH
Cheers
Carim

Conditional formatting
 

Hello
Excellent. THANK YOU. It works!!
so if I need for 2 months, what would I type =today()-60 ???
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

Conditional formatting
 

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

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

"Carim" wrote:

Hello Pascale,

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

=(TODAY()-B2)=7

HTH
Cheers
Carim

Conditional formatting
 

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

Conditional formatting
 

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

Conditional formatting
 

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!

"Carim" wrote:

Hello Pascale,

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

=(TODAY()-B2)=7

HTH
Cheers
Carim