Change color of font base on time range
 

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.

Change color of font base on time range
 

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.

Change color of font base on time range
 

Hi

I think Barb meant to say
=A1<=TODAY()+30 and choose format Green
choose Add
=A1<=TODAY()+7 and choose format Red

--
Regards

Roger Govier


"Barb Reinhardt" wrote in message
...
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.