Conditional Formatting(?) Based on Multiple Factors

Hello,

I'm attempting to assemble a Spreadsheet for work that helps to organize training requirements for employees.
The idea is that when a new employee starts working for us, we will know which training he/she needs based on his job title.

Below is a VERY simplified table example. We currently have 28 job titles/positions and 13 training sessions.
I would like the cells that the employee does NOT need to become a dark grey colour. So that we can fill in the trainings that they DO need with the date of completion.

Employee Training Matrix:

Name	Job Title	Training 1	Training 2	Training 3	Training 4
Jon	CEO			grey
Richard	Quality	grey			grey
Ryan	Sales
Jessica	Weekday Manager		grey		grey
Tiffany	Customer Service	grey	grey	grey
Cole	Driver	grey	grey

Job Requirement Table: (X = This is a required training for this specific job)

Job Title	Training 1	Training 2	Training 3	Training 4
CEO	X	X		X
Quality		X	X
Sales	X	X	X	X
Weekday Manager	X		X
Customer Service				X
Driver			X	X

What I have attempted:
I attempted to do a conditional format for a column and use an AND list of all the positions that did not meet my requirements, so that they would be grey. However, you are limited by the number of characters in a formula apparently. Is there a simpler/more elegant method? With 28 Job Titles, it can make my formulae pretty long.

I do have a Worksheet with the Training Matrix and another Worksheet with the Job Requirements. Is it possible to make them play off of each other?
Like... If Job Title = "Driver" , Compare Job Requirement Worksheet for "Driver" and if an "X" is in the spot, turn grey?

If something is unclear, let me know. I can try to make a mock spreadsheet to post later if needed.

Thanks,
Sieraaden

Attached an example spreadsheet. (May 31st, 2016 @ 15:13PM CST)

A mock up workbook would be really helpful so we can see what you've already tried in your conditional formatting.

To upload a sample, go to the Go Advanced button, then choose Manage Attachments which will open a new window. Select your file and click on the Upload button.

Select C2:O21, then choose conditional formatting, format by formula, and use the formula below:

=OFFSET('Job Requirements'!$A$1,MATCH($B2,'Job Requirements'!$A$2:$A$10,0),MATCH(C$1,'Job Requirements'!$A$1:$N$1,0)-1)<>""

Then pick grey. Did that do the trick?

EDIT: The versions below do the exact same thing on your sample, but are eversoslighty more versatile:

=OFFSET('Job Requirements'!$A$1,MATCH($B2,'Job Requirements'!$A$2:$A$10,0),MATCH(C$1,'Job Requirements'!$B$1:$N$1,0))<>""

=OFFSET('Job Requirements'!$A$1,MATCH($B2,'Job Requirements'!$A$2:$A$10,0),MATCH(C$1,'Job Requirements'!$B$1:$N$1,0))=""

Hmm,
Still working on it... for some reason it's not greying out anything at the moment.
I must have made an error somewhere...

=OFFSET('Required Documents'!$A$1,MATCH($F3,'Required Documents'!$A$2:$A$29,0),MATCH(G$1,'Required Documents'!$B$1:$N$1,0))=""

What does the $A$1 refer to?


---


In the "real deal"
The Training Matrix has the:
training titles from G2 --> S2
job titles from F3 --> end of sheet

Required Documents has the:
training titles from B1 --> N1
job titles from A2 --> A29


Edit:
Whoops! I had put G$1 in the formula, when it should have been G$2!
It looks like it has worked. but I need to run out of the house for a bit. and I'll check back in a few hours to confirm!
Thanks cantosh!

Edit 2:
It works! Thanks again!