muya said:
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