Date related Conditional Formatting

[Cameron Smith]

I would like to set up conditional formatting on a column so all cells in
the column containing dates that are older than 30 days will be red.

The column is formatted so dates read like this 04/02/04

How can I do this?

I have tried [brackets stand for the sections of the conditional formatting
dialog box]

[Cell] [is less than] [TODAY`-30]

As you can see I need help

Cameron

 

[Bernard Rey]

Cameron Smith wrote :

I would like to set up conditional formatting on a column so all cells in
the column containing dates that are older than 30 days will be red.

The column is formatted so dates read like this 04/02/04

How can I do this?

I have tried [brackets stand for the sections of the conditional formatting
dialog box]

[Cell] [is less than] [TODAY`-30]

As you can see I need help

Not that far, but the formula should be written just like it would inside a
worksheet cell:

[Cell] [is less than] [=TODAY()-30]

Seems to work fine

 

[Cameron Smith]

Cameron Smith wrote :

I would like to set up conditional formatting on a column so all cells in
the column containing dates that are older than 30 days will be red.

The column is formatted so dates read like this 04/02/04

How can I do this?

I have tried [brackets stand for the sections of the conditional formatting
dialog box]

[Cell] [is less than] [TODAY`-30]

As you can see I need help

Not that far, but the formula should be written just like it would inside a
worksheet cell:

[Cell] [is less than] [=TODAY()-30]

Seems to work fine

Thanks!!

That did it