Hello all, newbie and rather desperate here.

I am trying and failing miserably to figure out how I can have a UPC from a large list in one single column, to be highlighted (yellow) once the barcode has been scanned using a hand held barcode scanner.
For instance, if I had 500 different UPC codes in a single column and I physically had 200 different parts, can the corresponding UPC code on the worksheet be highlighted in a different colour (say yellow).

Do I also need a designated input cell for this to be able to happen and if so, can you advise on how this is done?

Appreciate any help that can be imparted.

Apologies if this has been requested before.

Many thanks in advance.