so i have a long number from a barcode.
0190027182300349320100024711190409210219892014g
in cells a6-a460
where the 3rd #to the 14th is fixed
90027182300349 and want cell g6-g460 output text tied to that number
so 90027182300349 would = to blue
90027182232456 would=to red
I tried the...