Forum Discussion
Conditional Formatting one cell based on multipule cells
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:
=AND(A2<>"",ISNUMBER(XMATCH(A2,$N$2:$N$35)))
