Conditional Format expiration dates

Vanessa Marrone 20 Reputation points
2023-06-02T15:11:04.9766667+00:00

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,

F#
F#
A strongly typed, multi-paradigm programming language developed by the F# Software Foundation, Microsoft, and open contributors.
60 questions
.NET F#
.NET F#
.NET: Microsoft Technologies based on the .NET software framework.F#: A strongly typed, multi-paradigm programming language developed by the F# Software Foundation, Microsoft, and open contributors.
98 questions
0 comments No comments
{count} votes

0 additional answers

Sort by: Most helpful