Conditional Format expiration dates

Question

Hello, I am trying to conditional format my excel worksheet to highlight a colour when the certification is expired. The expiry dates in this case would be 3 years or 1095 days from date of certification.

For example if I received a certification on 2019-05-07 and it expires in 1095 from then how would I create this formula.

Thank you,

Answer 1

hi!#Vanessa Marrone
one proposal
conditional formatting

=C3<=TODAY()-1095

C3 Copy only the format

Paste down and apply.

Hope it helps