excel partial match
I have a data base of serial numbers in column A. I will then scan serial numbers into column B. I want the cell to change color if (at least) the last 7 numbers of the serial number matches the data base in column A. This is because, sometimes when you scan a serial number it adds a prefix. But if the last 7 match then I want the cell to turn green confirming it matches a number in column A.
Note, I will not be scanning these numbers in a particular order so it must search the enitre column to see if it matches.
Thanks!
|