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 f...
The formula for the conditional formatting should read as follows:
=AND(A2<>"",ISNUMBER(XMATCH(A2,$N$2:$N$35)))