00:00We have compared two data sets on the same worksheet, but do you know how to compare two data sets
00:04in two different worksheets?
00:06Let me set the stage here.
00:07For example, we have two worksheets here, Worksheet 416A and 416B.
00:13The goal here is to identify duplicates in Worksheet 416B and then highlight the corresponding duplicate cell on Worksheet 416A.
00:22Here's how you do it.
00:23First, you go to Worksheet 416A and basically highlight column A data here like this.
00:28And after that, you go Home, Style, Conditional Formatting, New Rule.
00:34In this pop-up here for New Formatting Rule, you're going to select User Formula to determine which cell to
00:40format.
00:41And the formula that you're going to use, let's start off with a match function.
00:46The first argument on the match function is your lookup value, which is going to be A2, which is going
00:51to be in Worksheet 416A.
00:54Basically type A2 here, comma.
00:57After that, the second argument will be your lookup array.
01:01We're going to have to look up from Worksheet 416B here and basically highlight the column or the array of
01:09data set where you're going to look for that particular data for A2, which is the first argument here.
01:14And the third argument for the match is we're going to say 0 for the exact match.
01:20And basically what this match function does is returns the position where the match was found.
01:28And if it's not found, it will return an error message.
01:31So basically what we can capitalize out of this is to use a function called isNumber, which means if it
01:38returns the position, we're going to say yes.
01:40Go ahead and highlight it or conditional format it.
01:44And then don't forget the last parenthesis here.
01:46And after that, you're going to click on format.
01:49And then make sure you're on a fill tab here and select the color that you want to highlight when
01:54the match is made.
01:55I'm going to say highlight it with red and click OK and OK one more time.
02:00As you can see, any names that appears in Worksheet 416B is actually highlighted on this worksheet here, 416A.