Colour Code missing data

SeaBiskit 

I'm attaching an Excel version of your file here so others can see it without having to go to GoogleDrive.

My first reaction though is "Huh?!" First, it's because the arrangement of the columns doesn't look at all like you described it. Not a bid deal, but...

More significant: the data table in your "Set" column--describing the courses to be taken--is clean (because it's one course per cell). The data in column A--presumably the courses they have taken--is jumbled together when it's more than one and often not in the list prescribed at all.

So my first thought is that this data on what people have taken needs to be cleaned up. If you want to really have a solid and reliable data base, I'd recommend that the records be cleaned so that for each individual there is one row per course taken and that it include date the course was taken. Especially as you do more training of the individuals, having all that a given person has taken in one cell will just make things murky. On the other hand, a clean record that shows one row for each course that John Doe has taken, and I've started an example of what I mean in the attached.

I've also started but unable to get conditional formatting working correctly--somebody else no doubt can--to highlight those taken, those not.