Highlight the cell based on selected value

In the attached sheet, i am trying to highlight the cells based on the resource

for ex

A2..An defines skills
C1,D1,E1... are weeks
C2 till G4 are all resources available for that week for that skill set. (these values can extend..)

in A6 i have projects defined and resource assigned for that particular week.
My question is that When i place my cursor on C6 i need to highlight values wherver That value exists under skills
in this case Resource name is AP, so it should highlight C2,E4.

How can i achieve this , or any other way , all i need is somekind of indication that to know wherever those resources are booked and available
Thanks in advance