excel partial match

[BC2013]

I have a data base of serial numbers in column A. I will then sca
serial numbers into column B. I want the cell to change color if (a
least) the last 7 numbers of the serial number matches the data base i
column A. This is because, sometimes when you scan a serial number i
adds a prefix. But if the last 7 match then I want the cell to tur
green confirming it matches a number in column A.

Note, I will not be scanning these numbers in a particular order so i
must search the enitre column to see if it matches.

Thanks