Matching two columns/ Equal to?

[Cornelius deWeever]

I have two columns with over a thousand names on them, on different sheets. How can I compare them so they highlight the names that do not match the other list? I tried conditional format/ highlight/ equals to but can't figure out a formula.

Thanks

 

[rahulshewale1]

Hii,


Could you post sample which would we help you better



Regard
Rahul shewale

 

[vletm]

Cornelius deWeever
This would do that, press [ Do It ]
... after You have verified same settings.