Highlight Matches

The following are the basics of using the Highlight Matches macro.


The Highlight Matches macro highlights matching cells between two ranges.


graphic



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.


graphic


With the Highlight Matches macro, all matches in the purchases are highlighted in the parts list, as shown below.


graphic

Created with the Personal Edition of HelpNDoc: Full-featured EPub generator