Spreadsheet: 766311d1643835331-highlighting-a-cell-if-the-text-in-a-range-matches-the-text-in-a-separate-workbook-range-test-trainer-by-shift-list
Sheet: Formatted Sheet

 |  |  |  | Color coding is the desired Result as the names that match the other work book are green - no match is red. This is the desired result for all sheets.
Department | Process | Task | Primary/Secondary | Trainer 1st | Trainer 1st | Trainer 2nd | Trainer 2nd | Trainer 3rd | Trainer 3rd | [NAME] | [NAME]
DPT1 | Print | 6800 Press | Primary
DPT1 | Print | 6800 Press | Secondary
DPT1 | Print | 7600 Press | Primary
DPT1 | Print | 7600 Press | Secondary
DPT1 | Print | Epson P9000 | Primary
DPT1 | Print | Epson P9000 | Secondary
DPT1 | Bind | Magnet Laminator | Primary
DPT1 | Bind | Magnet Laminator | Secondary
DPT1 | Bind | D&K Laminator | Primary
DPT1 | Bind | D&K Laminator | Secondary
DPT1 | Bind | Lamimaster | Primary
DPT1 | Bind | Lamimaster | Secondary
DPT1 | Bind | Spartanix | Primary
DPT1 | Bind | Spartanix | Secondary
DPT1 | Bind | ID Card | Primary
DPT1 | Bind | ID Card | Secondary
DPT1 | Bind | [NAME] | Primary
DPT1 | Bind | [NAME] | Secondary
DPT1 | Bind | Magnet Applicator | Primary
DPT1 | Bind | Magnet Applicator | Secondary
DPT1 | Bind | Rotary Die Cutter | Primary
DPT1 | Bind | Rotary Die Cutter | Secondary
DPT1 | Bind | Titan Die Cutter | Primary
DPT1 | Bind | Titan Die Cutter | Secondary
DPT1 | Print | Dream Labo | Primary
DPT1 | Print | Dream Labo | Secondary
DPT1 | Bind | AP Driver | Primary
DPT1 | Bind | AP Driver | Secondary
DPT1 | Bind | AP Catcher | Primary
DPT1 | Bind | AP Catcher | Secondary
DPT1 | Ship | AP Finisher/Shipper | Primary
DPT1 | Ship | AP Finisher/Shipper | Secondary
DPT1 | Bind | Cut Pack Operator | Primary
DPT1 | Bind | Cut Pack Operator | Secondary
DPT1 | Ship | Finish | Primary
DPT1 | Ship | Finish | Secondary
DPT1 | Ship | Bin | Primary
DPT1 | Ship | Bin | Secondary
DPT1 | Ship | Ship | Primary
DPT1 | Ship | Ship | Secondary
DPT1 | Print | Batch Creation BOC | Primary
DPT1 | Print | Batch Creation BOC | Secondary
DPT1 | Bind | Sports Trading Cards | Primary
DPT1 | Bind | Sports Trading Cards | Secondary
DPT1 | Bind | Panoramics | Primary
DPT1 | Bind | Panoramics | Secondary
DPT1 | Bind | Sports Enlargements | Primary
DPT1 | Bind | Sports Enlargements | Secondary
DPT1 | Bind | Sports Mail Home | Primary
DPT1 | Bind | Sports Mail Home | Secondary
DPT1 | Print | UC Small Batch | Primary
DPT1 | Print | UC Small Batch | Secondary
DPT1 | Print | Power BI | Primary
DPT1 | Print | Power BI | Secondary
DPT2 | Print | HP Latex | Primary
DPT2 | Print | HP Latex | Secondary
DPT2 | Print | [NAME] | Primary
DPT2 | Print | [NAME] | Secondary
DPT2 | Bind | [NAME] | Primary
DPT2 | Bind | [NAME] | Secondary
DPT2 | Bind | Trimmer | Primary
DPT2 | Bind | Trimmer | Secondary
DPT2 | Bind | Fast Frame 1000 | Primary
DPT2 | Bind | Fast Frame 1000 | Secondary
DPT2 | Bind | Fast Frame 600 | Primary
DPT2 | Bind | Fast Frame 600 | Secondary
DPT2 | Bind | [NAME] | Primary
DPT2 | Bind | [NAME] | Secondary
DPT2 | Bind | Floating Frame Assy | Primary
DPT2 | Bind | Floating Frame Assy | Secondary
DPT2 | Bind | Underpinner | Primary
DPT2 | Bind | Underpinner | Secondary
DPT2 | Bind | MH&P Auto Under Pinner | Primary
DPT2 | Bind | MH&P Auto Under Pinner | Secondary
DPT2 | Ship | Canvas Ship | Primary
DPT2 | Ship | Canvas Ship | Secondary
DPT2 | Ship | Canvas OC Ship | Primary
DPT2 | Ship | Canvas OC Ship | Secondary
DPT2 | Bind | Swatches | Primary
DPT2 | Bind | Swatches | Secondary