Highlight the cell based on selected value



In a excel sheet, i am trying to highlight the cells based on the resource
existance

for ex

A2..A10 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