Use FORMAT - CONDITIONAL FORMAT

Frmula is for cell A1

=A1TODAY()+30

"deathzorro" wrote in message
oups.com...
Can anyone help me with this. I am looking to change the color of the
font in cell based on a time range. For example if I have 12/8/06 12:23
in a cell I would like the font for 12/8/06 12:23
to be green if that date if 30 days from todays date. Red if that date
is 7 days from todays date.