Hi

Was wondering if it is possible to use a lookup or other tool for the
following scenario:

A column on a sheet contains a list of unique references in the format
AA111111

A 2nd sheet also contains a list of unique references in the same format,
some of which may match a reference on the 1st sheet.

Is it possible to use a lookup to compare the columns on the 1st and 2nd
sheet, and highlight any matches on the 2nd sheet?

Thanks
Andy