Forum Discussion

Mom_of_Many's avatar
Mom_of_Many
Copper Contributor
Dec 03, 2019

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 number 2.  How can I do this in the simplest manner? 

 

Thank you for your help!

 

 

excel

1 Reply

  • ChrisMendoza's avatar
    ChrisMendoza
    Iron Contributor
    Dec 03, 2019

    Mom_of_Many -

    You could use conditional formatting.

    Sheet1

    Sheet2

    Conditional Formatting Rules

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

Resources