Conditional Formatting

  • Thread starter Thread starter Trish
  • Start date Start date
T

Trish

I have a date cell that I need to apply conditional formatting to when
the date is now one year later.

Example: A4 contains the date 1/1/2007 and today's date is in cell F2
with the formula [TODAY()]. If cell A4 is one year in the past I'd
like the font to change so I'll know that date is older than one year
from today's date.

Thanks for any help!
Trish
 
I have a date cell that I need to apply conditional formatting to when
the date is now one year later.

Example: A4 contains the date 1/1/2007 and today's date is in cell F2
with the formula [TODAY()]. If cell A4 is one year in the past I'd
like the font to change so I'll know that date is older than one year
from today's date.

Thanks for any help!
Trish
Click to expand...

I figured it out! Thanks anyway.
 
Back
Top