If I have a master list of 20 part numbers in one Excel column or worksheet
how can I compare each part numbers in the master column against actual
values/part numbers in another column or worksheet, and highlight in red the
missing parts in a third column? Is there a wizzard to help me or will I have
to write a complicated macro or loop?