I've a spreadsheet with 2 separate worksheets.

Sheet 1 shows a full list of products
Sheet 2 shows a list of products I intend to delete.

Both sheets have the sames column layout. A is product code, B is Product Description (some products are duplicated several times in Sheet 1).

How do I highlight any product codes on sheet 1 that are included in sheet 2?

See attached spreadsheet for eg.

I want the code 11234A from Sheet2 (A2) to be highlighted in Sheet1 (A2 & A5). ! will have approximately 7000 product lines on Sheet1 and approximately 600 in Sheet2

In an ideal world I'd like the cells to be highlighted in colour so I can sort them by the cell colour?

ExcelFirum Sample.xlsx