Hi there, please help with the following...

Working with two sheets, I have a list of alpha numeric referances in col.
A. I would like the cells in col. A on sheet 1 to show up as a differant
colour if they appear appear in list in col A on sheet 2.

What formula should I use in the conditional formatting?

Many Thanks.