Good Morning,

I wish to use a formula to highlight a date based on two criteria in two separate columns;

The first is the Date that will be in Column B.

I want it to highlight the date if : Today() is greater than that date in the cell plus 5 years (or 1824 days)

The second criteria I want is for the date to be only highlighted if the corresponding cell (in column A) does NOT contain the term ("Basic")


I have the formula:

=AND((TODAY()>(B1+1824)),A1=("Basic"))

which highlights the date correctly IF the term in Column A is "Basic" : But I cannot figure out how to insert the NOT statement to make the formula flip around so it only highlights those dates older than the 5 years requirement and NOT contain the "Basic" in column A.

Can anyone assist please ?