Conditional Formatting one cell based on multipule cells

Occasional Visitor

I am looking to find the formula that allows me to strike out a name based on a table of engineers as seen below.

I would like to strike out the names in the N Column


This is what I have so far, I am able to strike out Andrews name in only E2





1 Reply


The formula for the conditional formatting should read as follows: