Forum Discussion
Excel -- Find and Highlight from Two different spreadsheets
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 ...
You could use conditional formatting.
Sheet1
Sheet2
Conditional Formatting Rules
=ISNUMBER(MATCH(B3,Sheet1!$B$3:$B$7,0))