Numbers help

[raphaelraphael]

I have two spreadsheets of people's contact information. List A includes some people who are also on List B.

Is there a function where Numbers can automatically highlight the names on List B that are also on List A?

Thanks so much for any help.

 

[raphaelraphael]

Problem solved

Got an answer on an Excel forum that worked (in Excel), if anyone's interested:

Select column B and go to Format|Conditional Formatting, choose Formula Is and enter formula

=MATCH(B1,A:A,0)

Click Format and choose colour from Pattern tab.