Change color of font base on time range

  • Thread starter Thread starter deathzorro
  • Start date Start date
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.
 
Hi

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