Conditional Formatting one cell based on multipule cells

Copper Contributor

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

Fusion_Electrics_1-1673005464339.png

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

Fusion_Electrics_2-1673005518626.png

 

 

 

1 Reply

@Fusion_Electrics 

The formula for the conditional formatting should read as follows:

=AND(A2<>"",ISNUMBER(XMATCH(A2,$N$2:$N$35)))