VBA code to match values

I need a VBA application to match a column of numbers with the contents of a single cell, populated from a data matrix scanner. If a match is found, I want the computer monitor to turn red and say NG, if no match is found, the monitor will turn green and say OK, I want to also keep track of the unique numbers scanned, and the number of NG and OK results. A button to clear results is also needed.