highlighting a cell that contains date information

[muya]

I need to highlight a cell that contains a date. If the item is older than 5 years it needs to be red. I understand I need to use Conditional Formating but I can't think of the formula needed. Any help?

 

[athertm]

=IF(NOW()-E6>100,TRUE,FALSE)

where e6 contains the date you are checking.

This will use the format if the difference is 100 days.

 

[Brian from Maui]

I need to highlight a cell that contains a date. If the item is older than 5 years it needs to be red. I understand I need to use Conditional Formating but I can't think of the formula needed. Any help?

Depending on how accurate you want to be, you can use,

=DATEDIF(A1,TODAY(),"Y")>=5

 

[muya]

I need to highlight a cell that contains a date. If the item is older than 5 years it needs to be red. I understand I need to use Conditional Formating but I can't think of the formula needed. Any help?

Depending on how accurate you want to be, you can use,

=DATEDIF(A1,TODAY(),"Y")>=5

awesome, this worked beautifully. thank you.