Spreadsheet: 716602d1612280807-trying-to-use-conditional-formatting-to-color-cells-that-match-list-on-other-spreadsheet-using-named-ranges-in-conditional-formatting-tdarcy2188-
Sheet: Sorting Data

Chemo | Supply | TPA | Blood | New Form | Gas | Non Form |  | Chemo | Supply | TPA | Blood | New Form | Gas | Non Form
*Abraxane* | *Auxiliary Labels* | *Activase* | *Albumin* | *Amiodarone 100mg* | *Forane* | *Sotradecol* |  | Abraxane | Auxiliary Labels | Activase | Albumin | Amiodarone 100mg | Forane | Sotradecol
*Adcetris* | *[NAME]* |  | *Alburx* | *Andexanet Alfa* | *Suprane* |  |  | [NAME] | [NAME] |  | Alburx | Andexanet Alfa | Suprane
*[NAME] | *Bag* |  | *Gamunex* | *Andexxa* | *Terrell* |  |  | [NAME] | Bag |  | [NAME] | Andexxa | Terrell
*Alimta* | *BD SY ML LL 100* |  | *Integrilin* | *Antihemophilic* | *Ultane* |  |  | Alimta | BD SY ML LL 100 |  | Integrilin | Antihemophilic | Ultane
*Avastin* | *Dispensing Pins* |  | *K Centra* | *ARIPirazole lauroxil* |  |  |  | Avastin | [NAME] |  | K Centra | ARIPirazole lauroxil
*Azacitidine* | *[NAME]* |  | *Privagen* | *Aristada* |  |  |  | Azacitidine | [NAME] |  | Privagen | Aristada
*Benamustin* | *Exacta Med Syringes* |  | *Rhophylac* | *Aristada Initio* |  |  |  | Benamustin | [NAME] |  | [NAME] | Aristada Initio
*Bendeka* | *Filter Needles* |  |  | *Atezolizumab* |  |  |  | Bendeka | Filter Needles |  |  | Atezolizumab
*Bleomycin* | *Hydrogen Peroxide* |  |  | *Azithromycin 500mg* |  |  |  | Bleomycin | Hydrogen Peroxide |  |  | [NAME] 500mg
*Bortezomib* | *Isopro* |  |  | *Brevital* |  |  |  | Bortezomib | Isopro |  |  | Brevital
*Brentuximab* | *IV Seals* |  |  | *Buprenorphine* |  |  |  | Brentuximab | IV Seals |  |  | Buprenorphine
*Camptosar* | *Kerr Oval Vials Plastic* |  |  | *Carbocaine* |  |  |  | Camptosar | Kerr Oval Vials Plastic |  |  | Carbocaine
*Carbazetaxol* | *Kleenex* |  |  | *Cetirizine 5mg* |  |  |  | Carbazetaxol | Kleenex |  |  | Cetirizine 5mg
*Carboplatin* | *Label* |  |  | *Chlorhexidine Foam* |  |  |  | Carboplatin | Label |  |  | [NAME]
*Carfilzomib* | *Lavender Oil* |  |  | *CrystalViolet(Gential)* |  |  |  | Carfilzomib | Lavender Oil |  |  | CrystalViolet(Gential)
*[NAME]* | *MultiAd Syringe* |  |  | *DDAVP* |  |  |  | [NAME] | MultiAd Syringe |  |  | DDAVP
*Cyclophosphomide* | *Peppermint Oil* |  |  | *Diphtheria* |  |  |  | Cyclophosphomide | Peppermint Oil |  |  | Diphtheria
*Cyramza* | *Pharma – Hol 70* |  |  | *Dolutegravir* |  |  |  | Cyramza | Pharma – Hol 70 |  |  | Dolutegravir
*Cytoxan* | *SUP ASP/INJ FLT* |  |  | *Epoetin alfa-epbx* |  |  |  | Cytoxan | SUP ASP/INJ FLT |  |  | Epoetin alfa-epbx
*Dacarbazine* | *Surgical Snow* |  |  | *Epoprostenol* |  |  |  | Dacarbazine | Surgical Snow |  |  | Epoprostenol
*Dacogen* | *Surgicel* |  |  | *Eravacycline* |  |  |  | Dacogen | Surgicel |  |  | Eravacycline
*Daratumumab* | *Surgifoam* |  |  | *FirVANQ* |  |  |  | Daratumumab | Surgifoam |  |  | FirVANQ
*Darzalex* | *Surgilube* |  |  | *Flolan* |  |  |  | [NAME] | Surgilube |  |  | Flolan
*Decitabine* | *Vaseline* |  |  | *Fluconazole 150mg* |  |  |  | Decitabine | Vaseline |  |  | Fluconazole 150mg
*Docetaxel* | *Vial Empty* |  |  | *Hibiclens* |  |  |  | Docetaxel | Vial Empty |  |  | Hibiclens
*Doxil* | *White Petroleum* |  |  | *Humate-P* |  |  |  | Doxil | White Petroleum |  |  | Humate-P
*Doxorub* |  |  |  | *Infliximab-abda* |  |  |  | Doxorub |  |  |  | Infliximab-abda
*Doxorubicin* |  |  |  | *Mepivacaine* |  |  |  | [NAME] |  |  |  | Mepivacaine
*Eligard22* |  |  |  | *Methohexital* |  |  |  | Eligard22 |  |  |  | Methohexital
*Ellence* |  |  |  | *Miconazole Nitrate* |  |  |  | Ellence |  |  |  | Miconazole Nitrate
*Eloxatin* |  |  |  | *Naloxone* |  |  |  | Eloxatin |  |  |  | Naloxone
*Emend* |  |  |  | *Naltrexone extended* |  |  |  | Emend |  |  |  | Naltrexone extended
*Erbitux* |  |  |  | *Oseltamivir* |  |  |  | Erbitux |  |  |  | Oseltamivir
*Etoposide* |  |  |  | *Pentacel* |  |  |  | Etoposide |  |  |  | Pentacel
*Faslodex* |  |  |  | *Poliovirius* |  |  |  | Faslodex |  |  |  | Poliovirius
*Fluoruracil* |  |  |  | *Renflexis* |  |  |  | Fluoruracil |  |  |  | Renflexis
*Ganciclovir* |  |  |  | *Retacrit* |  |  |  | Ganciclovir |  |  |  | Retacrit
*Gemcitabine* |  |  |  | *Revefenacin* |  |  |  | Gemcitabine |  |  |  | [NAME]
*Gemzar* |  |  |  | *Robitussin DM* |  |  |  | Gemzar |  |  |  | Robitussin DM
*Halaven* |  |  |  | *Spironolactone* |  |  |  | Halaven |  |  |  | Spironolactone
*Herceptin* |  |  |  | *Suboxone* |  |  |  | [NAME] |  |  |  | Suboxone
*Hycamtin* |  |  |  | *Subutex* |  |  |  | Hycamtin |  |  |  | Subutex
*Imfinzi* |  |  |  | *Tamiflu* |  |  |  | Imfinzi |  |  |  | Tamiflu
*Ipilumimab* |  |  |  | *Tecentriq* |  |  |  | Ipilumimab |  |  |  | Tecentriq
*Irinotecan* |  |  |  | *Tetanus Toxoid* |  |  |  | Irinotecan |  |  |  | Tetanus Toxoid
*Kadcyla* |  |  |  | *Tivicay* |  |  |  | Kadcyla |  |  |  | Tivicay
*Keytruda* |  |  |  | *Urea (URE-Na)* |  |  |  | Keytruda |  |  |  | Urea (URE-Na)
*Kyprolis* |  |  |  | *Ursodiol* |  |  |  | Kyprolis |  |  |  | Ursodiol
*Leucovorin* |  |  |  | *Vancomycin Oral* |  |  |  | Leucovorin |  |  |  | [NAME]
*Libtayo* |  |  |  | *Veletri* |  |  |  | Libtayo |  |  |  | Veletri
*Liposomal* |  |  |  | *Vivitrol* |  |  |  | Liposomal |  |  |  | Vivitrol
*Methotrexate* |  |  |  | *Xarelto* |  |  |  | Methotrexate |  |  |  | Xarelto
*Nano-particulate* |  |  |  | *Xerava* |  |  |  | Nano-particulate |  |  |  | [NAME]
*Neulasta* |  |  |  | *Yupelri* |  |  |  | Neulasta |  |  |  | Yupelri
*Neuplasta* |  |  |  | *5-FU* |  |  |  | Neuplasta |  |  |  | 5-FU
*Neupogen* |  |  |  |  |  |  |  | Neupogen
*Nevelbine* |  |  |  |  |  |  |  | Nevelbine
*NPlate* |  |  |  |  |  |  |  | NPlate
*Oncovin* |  |  |  |  |  |  |  | Oncovin
*Opdivo* |  |  |  |  |  |  |  | Opdivo
*Oxaliplatin* |  |  |  |  |  |  |  | [NAME]
*Paclitaxel* |  |  |  |  |  |  |  | Paclitaxel
*Palonosetron* |  |  |  |  |  |  |  | Palonosetron
*Pantiumumab* |  |  |  |  |  |  |  | [NAME]
*Paraplatin* |  |  |  |  |  |  |  | Paraplatin
*Perjeta* |  |  |  |  |  |  |  | Perjeta
*Platinol* |  |  |  |  |  |  |  | Platinol
*Premetrexed* |  |  |  |  |  |  |  | Premetrexed
*Procrit* |  |  |  |  |  |  |  | Procrit
*Rituxin* |  |  |  |  |  |  |  | Rituxin
*Taxol* |  |  |  |  |  |  |  | Taxol
*Taxotere* |  |  |  |  |  |  |  | Taxotere
*Tecentri Q* |  |  |  |  |  |  |  | Tecentri Q
*Toposar* |  |  |  |  |  |  |  | Toposar
*Topotecan* |  |  |  |  |  |  |  | Topotecan
*Trelstar* |  |  |  |  |  |  |  | Trelstar
*Vectibix* |  |  |  |  |  |  |  | Vectibix
*Velban* |  |  |  |  |  |  |  | Velban
*Velcade* |  |  |  |  |  |  |  | Velcade
*Vidaza* |  |  |  |  |  |  |  | Vidaza
*Vinblastine* |  |  |  |  |  |  |  | Vinblastine
*Vincristine* |  |  |  |  |  |  |  | Vincristine
*Vinorelbine* |  |  |  |  |  |  |  | Vinorelbine
*Yervoy* |  |  |  |  |  |  |  | Yervoy
*Zoledronic Acid* |  |  |  |  |  |  |  | [NAME]