Hello, I am not an expert or even good at using excel but I am looking for some help.

I am using excel to scan barcodes so when the first barcode is scanned it will be in green and then every time the same code is scanned it is in green. Until a incorrect or different barcode is scanned, it will show in red.

I need help trying to either make a VBA or conditional formatting setting to get the screen to freeze on the red color and no longer except input till the marco CTRL-D is used to reset. I need help making this work when red comes up so that you have to deal with the incorrect scan.

Also If there is a way to make a sound through VBA or formatting when the wrong barcode(red color) is scanned.

There are around 20,000 different barcodes with letters and numbers so it will have to be based off the first cell which is always the correct barcode till it is being reset.

excel color.PNG
color format.PNG