Conditional Formatting

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
 
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
Click to expand...

I figured it out! Thanks anyway.
 

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

PLEASE HELP! need conditional formatting related to date, blank cellsand today's date 16
Date Expiration and highlight 3
concatenating two fields in one cell, of which one is a date. 3
Conditional formating 4
Comparison of columns using Conditional Formatting 3
Conditional formatting based on formula cell 6
Excel conditional formatting with Weeknum 4
CONDITIONAL FORMATTING BETWEEN SHEETS 1

Top