Excel -- Find and Highlight from Two different spreadsheets

[Mom_of_Many]

Hello, 

Looking for some help with finding and highlighting information from two different spreadsheets. 

The first spreadsheet has a list of names that I need to find and highlight in spreadsheet number 2.  How can I do this in the simplest manner? 

Thank you for your help!

[#2]

@Mom_of_Many -

You could use conditional formatting.

Sheet1

Sheet2

Conditional Formatting Rules

=ISNUMBER(MATCH(B3,Sheet1!$B$3:$B$7,0))