It is a common task in Excel to have
to compare two lists and highlight those items that appear in one list and not
on the other.
To do this we can use the Vlookup
function within the Conditional Formatting tool. The Vlookup function can be
used to lookup an item from one list in the other. The Conditional Formatting
tool can then be used to highlight the missing items.
