F#
A strongly typed, multi-paradigm programming language developed by the F# Software Foundation, Microsoft, and open contributors.
70 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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,
hi!#Vanessa Marrone
one proposal
conditional formatting
=C3<=TODAY()-1095
C3 Copy only the format
Paste down and apply.
Hope it helps