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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change cell color if date exceeds formula 1
Changing the Status of Cell 1
conditional formatting date 2
Change colour of font in a textbox? 2
Find within Date Range 4
Excel Colour code dates 1
Formatting based on date ranges 2
Formatting based on date ranges 1

Top