I apologize if this is in the wrong thread.
I had originally posted a work book that I had names moved to a "Validated Trainer List" if they met a set of criteria. This "Validated Trainer List" is on the worksheet titled "Trainers" in the attached workbook titled "Test Workbook - Copy"
I now have a separate workbook where managers list out their trainers for their teams. This workbook (attached) is titled "TEST Trainer By Shift List."
What I would like to do is conditionally format the latter workbook so that if a name shows up on any worksheet of the workbook "Test Trainer By Sheet List" matches a name on the worksheet "Trainers" it will highlight the cell green. If there is no match it will highlight the name in red.
Simply put if a name on the Trainer by Shift (shortened) workbook is a Validated Trainer they are marked green, and if they are not a validated trainer they are red.
The workbook "TEST Trainer By Shift List" is appropriately color coded with the desired result.
Thank you for any help!
Bookmarks