Highlight the cell based on selected value

[Max]

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

 

[Shane Devenshire]

Hi,

No doubt this can be done but we need to see some dummy data with the
explanation to match that example.

 

[Max]

Ya i agree to what you say but these threads have no options for attachment.
Well if there is any existing here let me know
IF you are really interested in looking into my problem i can place sample
sheet in 4shared.com and you can access or please provide meyour email id
will write to you
thanks for your help
max