Conditional Formatting

  • Thread starter Thread starter Gina McRill
  • Start date Start date
G

Gina McRill

What formula would we use to change the color of the font
on a date that is equal to 5 days from "today's" date?
Example: Today is 10/1/03 we want the color to change to
blue five days from today (10/6/03).
Also we want it to change to red on the 6th day and
greater.
Example: Today is 10/1/03 we want the color to change to
red starting on the 6th day (10/7/03) and forward.

Thanks,

Gina
 
Gina McRill said:
What formula would we use to change the color of the font
on a date that is equal to 5 days from "today's" date?
Example: Today is 10/1/03 we want the color to change to
blue five days from today (10/6/03).
Also we want it to change to red on the 6th day and
greater.
Example: Today is 10/1/03 we want the color to change to
red starting on the 6th day (10/7/03) and forward.

Thanks,

Gina
Click to expand...

=TODAY()+5 as condition one with formatting Fonts Blue
=TODAY()+6 as condition two with formatting Patterns Red

Of course you will never get to day 5 after today, let alone day 6 so

you have to change your question. For your example:
=TODAY()=datevalue("10/6/03") condition one with fomatting Fonts Blue
=TODAy()>datevalue("10/6/03") condition two with formatting Fonts Red ed
 
One way:

Assume the date is in A1.

CF1: =(TODAY()-A1)=5 ==> Blue
CF2: =(TODAY()-A1)>5 ==> Red
 
Back
Top