The following are the basics of using the Highlight Matches macro.
The Highlight Matches macro highlights matching cells between two ranges.
For example, the spreadsheet below has a list of parts and which parts have been ordered each month. To check which parts have not been ordered would require many VLOOKUP functions.
With the Highlight Matches macro, all matches in the purchases are highlighted in the parts list, as shown below.
Created with the Personal Edition of HelpNDoc: Full-featured EPub generator