Hi

you can use conditional formatting for this
select your dates
choose format / conditonal formatting
choose
formula is
type
=$A1<=TODAY()-30
where $A1 is the first cell with a date in it
click FORMAT
set your formatting
click OK twice

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"vdefilippo" wrote in message
...
I would like to know if I can format a cell to, change to a color, after 30
days have passed from the date that is in the cell.