Change color of font base on time range

D

deathzorro

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.
 
R

Roger Govier

Hi

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