Jan 06 2023 03:46 AM
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
Jan 06 2023 05:53 AM
The formula for the conditional formatting should read as follows:
=AND(A2<>"",ISNUMBER(XMATCH(A2,$N$2:$N$35)))