Conditionally formatting one cell based on text in another.

Hey there,
Sorry, this is a bit long winded but needs to be. I work in the planning department of a call center, where there are several different skills needed for people in every different department. The reason for this is that the automated phone service can direct a caller to someone who can actually help them. Some agents can have up to 12 different skills allotted to them. The problem is that sometimes, for whatever reason, an employee may have one of those skills removed from them and it may not be spotted so it's not added back on, which means we have on less person than we thought answering calls on that skill. So here's the thing. I want to create a skills list with an alarm. I have a list of all of our agents with the necessary skills listed beside them. I want to be able to run a report that will show me if they are missing a skill. Is this some kind of lookup and, if so, how would I do that?