Conditional Formatting - Match cells against reference row

[Itsmeerc]

Hey.

I have several columns of countries, drawn from different data sources (columns B, C and D in the sample image) which I want to compare with a master reference column (column A) to identify any discrepancies in spelling/strange punctuation. Therefore, I want to apply conditional formatting to all cells in columns B-D which highlight in red any cells which do not have an exact match with any cell in column A. I can't quite find the right formula syntax to make this happen, so would appreciate any advice.

 

[Fluff]

How about

=AND(B2<>"",ISNA(MATCH(B2,$A$2:$A$100,0)))

 

[Itsmeerc]

How about

=AND(B2<>"",ISNA(MATCH(B2,$A$2:$A$100,0)))

Thank you! Worked as I wanted

 

[Fluff]

You're welcome & thanks for the feedback.