Conditional Formatting

H

Humpy

Can anyone help!

Is it possible for a cell to change colour after a given period of time has
elapsed.

ie 30 days after the 01/02/06 or 60 days after the 20/02/06.

Regards
Humpy
 
D

Duke Carey

If those dates appear somewhere in the spreadsheet, then yes.

Assume 01/02/06 is in cell A1, and you want cell B1 to change color when 30
days have lapsed

Select B1, go to Format->Conditional Formatting.. and select Formula Is and
use the formula

=$A$1<(TODAY()-30)

then click on the format button, go to the patterns tab and choose the color
you want the cell to display. OK your way out & you're done
 
Top