Spreadsheet: 453959d1459536214-conditional-formatting-formulas-for-alphanumeric-codes-in-other-cells-copy-of-2016-sample-data
Sheet: Reference Sheet

Mix ID | MIX ID Description |  | Test Lab |  | Customer | Customer ID Description
03A24FI |  |  | Parkland Geo |  | 88
05A24FI |  |  | [NAME] |  | C3CITGRA
10A22FI |  |  | WGS |  | C51646297
10A24FI |  |  | WSP |  | C51709790
15A21LC |  |  | Opus [NAME] |  | C51843365
20A11ST |  |  | Northland |  | C54SEA
20A21PH |  |  | EcoVisions |  | C58113AB
25A11ST |  |  | HerringWert |  | C5ABCON
25A12IC |  |  |  |  | C5ABIND
25A21FW |  |  |  |  | C5ACLBUI
25A22CB |  |  |  |  | C5ADVHOI
25N11IF |  |  |  |  | C5ADVVAL
25N12BF |  |  |  |  | C5AGRFOU
25N14GT |  |  |  |  | C5ALCHOM
25N21IF |  |  |  |  | C5ALHMAJ
30A11ST |  |  |  |  | C5ALLDEC
30A21FW |  |  |  |  | C5ALLPEA
30C11DU |  |  |  |  | C5ALLSTA
30C12SP |  |  |  |  | C5AQUUTI
30D11CS |  |  |  |  | C5ARKCON
30D11CW |  |  |  |  | C5ATCELE
30D11TS |  |  |  |  | C5BARCON
30D11TW |  |  |  |  | C5BBMAN
30D12PC |  |  |  |  | C5BEADAY
30N11IF |  |  |  |  | C5BETENT
30N14GT |  |  |  |  | C5BLAHOM
30N21IF |  |  |  |  | C5BLASWA
32A11ST |  |  |  |  | C5BLURID
32A12IC |  |  |  |  | C5BOENAT
32A21FW |  |  |  |  | C5BOGBRA
32A21LT |  |  |  |  | C5BRCCON
32C11EF |  |  |  |  | C5BROSER
32C12SP |  |  |  |  | C5BUIIT
32C13EX |  |  |  |  | C5CAMCON
32C21EF |  |  |  |  | C5CANAIR
32N11IF |  |  |  |  | C5CANHOM
32N21IF |  |  |  |  | C5CARCON
35A11ST |  |  |  |  | C5CASRID
35A21FW |  |  |  |  | C5CEAENT
35C11EF |  |  |  |  | C5CECPRE
35C21EF |  |  |  |  | C5CHAAUT
35N11IF |  |  |  |  | C5CHADEV
35N21IF |  |  |  |  | C5CHAHOM
30A21FP |  |  |  |  | C5CHAOIL
 |  |  |  |  | C5CHERON
 |  |  |  |  | C5CHIVAL
 |  |  |  |  | C5CHODAL
 |  |  |  |  | C5CHREVA
 |  |  |  |  | C5CLABUI
 |  |  |  |  | C5CNRL
 |  |  |  |  | C5CORAL
 |  |  |  |  | C5COUGRA
 |  |  |  |  | C5COUPUM
 |  |  |  |  | C5COVHOM
 |  |  |  |  | C5CROLEA
 |  |  |  |  | C5CURWOR
 |  |  |  |  | [NAME]
 |  |  |  |  | C5DANCON
 |  |  |  |  | C5DANTRU
 |  |  |  |  | C5DAVCON
 |  |  |  |  | C5DDWELL
 |  |  |  |  | C5DECCON
 |  |  |  |  | C5DEECON
 |  |  |  |  | C5DEEPR
 |  |  |  |  | C5DESBUI
 |  |  |  |  | C5DIAWIL
 |  |  |  |  | C5DIXCON
 |  |  |  |  | C5DIXHOM
 |  |  |  |  | C5DMBSON
 |  |  |  |  | C5DOBOIL
 |  |  |  |  | C5DORHOM
 |  |  |  |  | C5DORSTE
 |  |  |  |  | C5DOUHEL
 |  |  |  |  | C5DOUSTA
 |  |  |  |  | C5DUCCON
 |  |  |  |  | C5DWGCON
 |  |  |  |  | C5DYCRAN
 |  |  |  |  | C5EAGBUI
 |  |  |  |  | C5EAGEX
 |  |  |  |  | C5EH1CON
 |  |  |  |  | C5ENCCOR
 |  |  |  |  | C5ENEDRI
 |  |  |  |  | C5ENELOG
 |  |  |  |  | C5ENVBUI
 |  |  |  |  | C5EQUREN
 |  |  |  |  | C5EVEENE
 |  |  |  |  | C5EVEPAR
 |  |  |  |  | C5EVETRA
 |  |  |  |  | C5EXCNOR
 |  |  |  |  | C5EZBAC
 |  |  |  |  | C5FIRGEN
 |  |  |  |  | C5FORCON
 |  |  |  |  | C5FOUTIR
 |  |  |  |  | C5FREPAU
 |  |  |  |  | C5GASDRI
 |  |  |  |  | C5GEOCON
 |  |  |  |  | C5GERCON
 |  |  |  |  | C5GLEARM
 |  |  |  |  | C5GLEHOL
 |  |  |  |  | [NAME]
 |  |  |  |  | C5GOLCRE
 |  |  |  |  | C5GORCON
 |  |  |  |  | C5GOWEL
 |  |  |  |  | C5GPCONC
 |  |  |  |  | C5GPCUS
 |  |  |  |  | C5GPEAG
 |  |  |  |  | C5GPLAW
 |  |  |  |  | C5GPMAZ
 |  |  |  |  | C5GRACON
 |  |  |  |  | C5GRAHAV
 |  |  |  |  | C5GREACR
 |  |  |  |  | C5GREBUI
 |  |  |  |  | C5GREWOOD
 |  |  |  |  | C5GRICON
 |  |  |  |  | C5GRIDRI
 |  |  |  |  | C5GVCOL
 |  |  |  |  | C5HAMEXC
 |  |  |  |  | C5HANFOR
 |  |  |  |  | C5HARJAK
 |  |  |  |  | C5HEAGAT
 |  |  |  |  | C5HIDLAK
 |  |  |  |  | C5HIGCOU
 |  |  |  |  | C5HIGMAR
 |  |  |  |  | C5HIGNOO
 |  |  |  |  | C5HILENT
 |  |  |  |  | C5HISHOM
 |  |  |  |  | C5HIWSTE
 |  |  |  |  | C5HMMEAT
 |  |  |  |  | C5HOADAL
 |  |  |  |  | C5HOMBY
 |  |  |  |  | C5HOMINC
 |  |  |  |  | C5HORHIL
 |  |  |  |  | C5HORLAK
 |  |  |  |  | C5HORNOR
 |  |  |  |  | C5HOWMIK
 |  |  |  |  | C5HRHHOM
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | C5IMPMEC
 |  |  |  |  | C5INLCON
 |  |  |  |  | C5INLINE
 |  |  |  |  | C5INLVAL
 |  |  |  |  | C5INNCIV
 |  |  |  |  | C5INTCON
 |  |  |  |  | C5IPASER
 |  |  |  |  | C5IRODRI
 |  |  |  |  | C5IRORIN
 |  |  |  |  | C5IWASTA
 |  |  |  |  | C5JAECON
 |  |  |  |  | C5JAYTRU
 |  |  |  |  | C5JENTRU
 |  |  |  |  | C5JERDEV
 |  |  |  |  | C5JJCON
 |  |  |  |  | C5JONBYR
 |  |  |  |  | C5KALCON
 |  |  |  |  | C5KALMCO
 |  |  |  |  | C5KAYCON
 |  |  |  |  | C5KCMCON
 |  |  |  |  | C5KCOCON
 |  |  |  |  | C5KENEQU
 |  |  |  |  | C5KENFAR
 |  |  |  |  | C5KEYPRO
 |  |  |  |  | C5KLASS
 |  |  |  |  | C5KMBUI
 |  |  |  |  | C5KSHA
 |  |  |  |  | C5LAFCON
 |  |  |  |  | C5LANPRO
 |  |  |  |  | C5LAPWOR
 |  |  |  |  | C5LAVHOM
 |  |  |  |  | C5LAWDAR
 |  |  |  |  | [NAME]
 |  |  |  |  | C5LBCON
 |  |  |  |  | C5LEBBRA
 |  |  |  |  | C5LEDCON
 |  |  |  |  | C5LEGHOM
 |  |  |  |  | C5LEXPRO
 |  |  |  |  | C5LFCCON
 |  |  |  |  | C5LIBHOM
 |  |  |  |  | C5LOEABE
 |  |  |  |  | C5LORHOM
 |  |  |  |  | C5LSMLEE
 |  |  |  |  | C5MAICON
 |  |  |  |  | C5MALCON
 |  |  |  |  | C5MCTCAM
 |  |  |  |  | C5MILARR
 |  |  |  |  | C5MILBUI
 |  |  |  |  | C5MILCON
 |  |  |  |  | C5MILMAC
 |  |  |  |  | C5MINBRO
 |  |  |  |  | C5MMTRU
 |  |  |  |  | C5MODRES
 |  |  |  |  | C5MONHOM
 |  |  |  |  | C5MOOCON
 |  |  |  |  | C5MPIINC
 |  |  |  |  | C5MRNINV
 |  |  |  |  | C5MRPLU
 |  |  |  |  | C5MTIDA
 |  |  |  |  | C5MURHAU
 |  |  |  |  | C5MYSHOM
 |  |  |  |  | C5NAGJOH
 |  |  |  |  | C5NECCON
 |  |  |  |  | C5NESCON
 |  |  |  |  | C5NEWCOR
 |  |  |  |  | C5NORCHR
 |  |  |  |  | C5NORCON
 |  |  |  |  | C5NORELE
 |  |  |  |  | C5NORFEN
 |  |  |  |  | C5NORMAT
 |  |  |  |  | C5NORPRO
 |  |  |  |  | C5NORPUM
 |  |  |  |  | C5OATJAC
 |  |  |  |  | C5OVEDOO
 |  |  |  |  | C5PALCON
 |  |  |  |  | C5PARBRI
 |  |  |  |  | C5PASMAN
 |  |  |  |  | C5PATCON
 |  |  |  |  | C5PEACOU
 |  |  |  |  | C5PEBEN
 |  |  |  |  | C5PENDAR
 |  |  |  |  | C5PERBAC
 |  |  |  |  | C5PERINS
 |  |  |  |  | C5PETDAL
 |  |  |  |  | C5PHOTRE
 |  |  |  |  | C5PIPBUI
 |  |  |  |  | C5PODDEV
 |  |  |  |  | C5POLCON
 |  |  |  |  | C5PRADIS
 |  |  |  |  | C5PRAHOM
 |  |  |  |  | C5PRECUR
 |  |  |  |  | C5PRETEK
 |  |  |  |  | C5PRICHA
 |  |  |  |  | C5PRIHOM
 |  |  |  |  | C5PRIPRO
 |  |  |  |  | C5PROFOR
 |  |  |  |  | C5PUDRON
 |  |  |  |  | C5PURINT
 |  |  |  |  | C5RAHCA
 |  |  |  |  | C5RAMCON
 |  |  |  |  | C5RBCUR
 |  |  |  |  | C5RECCON
 |  |  |  |  | C5REDCUS
 |  |  |  |  | C5REEATW
 |  |  |  |  | C5REEENE
 |  |  |  |  | C5REGOIL
 |  |  |  |  | C5REIFOU
 |  |  |  |  | C5RENDEV
 |  |  |  |  | C5RENWQU
 |  |  |  |  | C5REXREC
 |  |  |  |  | C5RHAR
 |  |  |  |  | C5RICREA
 |  |  |  |  | C5RITBRO
 |  |  |  |  | C5RIVGOL
 |  |  |  |  | C5RMPENE
 |  |  |  |  | C5ROBJAS
 |  |  |  |  | C5ROCHOM
 |  |  |  |  | C5ROCJOH
 |  |  |  |  | C5ROCK
 |  |  |  |  | C5ROCKMO
 |  |  |  |  | C5RONTRE
 |  |  |  |  | C5ROSHOM
 |  |  |  |  | C5ROYETE
 |  |  |  |  | C5RUSCON
 |  |  |  |  | C5RYCEXC
 |  |  |  |  | C5RYSHOM
 |  |  |  |  | C5SADHIL
 |  |  |  |  | C5SANMOH
 |  |  |  |  | C5SBFEN
 |  |  |  |  | C5SCEHEI
 |  |  |  |  | C5SCHAND
 |  |  |  |  | C5SCHCAN
 |  |  |  |  | C5SCHINC
 |  |  |  |  | C5SCOBUI
 |  |  |  |  | C5SCOHOM
 |  |  |  |  | C5SEEHOM
 |  |  |  |  | C5SEISON
 |  |  |  |  | C5SEVGEN
 |  |  |  |  | C5SHACON
 |  |  |  |  | C5SHAD
 |  |  |  |  | C5SHALAN
 |  |  |  |  | C5SHARAT
 |  |  |  |  | C5SILM
 |  |  |  |  | C5SILMOU
 |  |  |  |  | C5SILTEC
 |  |  |  |  | C5SINOPP
 |  |  |  |  | C5SOUDES
 |  |  |  |  | C5STECON
 |  |  |  |  | C5STEIND
 |  |  |  |  | C5STOAND
 |  |  |  |  | C5STRCON
 |  |  |  |  | C5STU2013
 |  |  |  |  | C5STUHOM
 |  |  |  |  | C5SUNCON
 |  |  |  |  | C5SUNLAN
 |  |  |  |  | C5SURCON
 |  |  |  |  | C5SURGRA
 |  |  |  |  | C5TEGCON
 |  |  |  |  | C5TEMHOM
 |  |  |  |  | C5TERELE
 |  |  |  |  | C5THEYAR
 |  |  |  |  | C5THOCON
 |  |  |  |  | C5TITMAS
 |  |  |  |  | C5TORIND
 |  |  |  |  | C5TOWWEM
 |  |  |  |  | C5TRACON
 |  |  |  |  | C5TRAPEA
 |  |  |  |  | C5TRICON
 |  |  |  |  | C5TRUFAB
 |  |  |  |  | C5TURFLI
 |  |  |  |  | C5UFA
 |  |  |  |  | C5UNIHOM
 |  |  |  |  | C5URBESC
 |  |  |  |  | C5URICON
 |  |  |  |  | C5VALCON
 |  |  |  |  | C5VISCON
 |  |  |  |  | C5VISHOM
 |  |  |  |  | C5WALGRA
 |  |  |  |  | C5WALNER
 |  |  |  |  | C5WARBRO
 |  |  |  |  | C5WATPRO
 |  |  |  |  | C5WERCHR
 |  |  |  |  | C5WERHOM
 |  |  |  |  | C5WESCON
 |  |  |  |  | C5WESMAN
 |  |  |  |  | C5WHIRID
 |  |  |  |  | C5ZERSPI
 |  |  |  |  | C5ZLMCON
 |  |  |  |  | PLC