Highlight the cell based on selected value

**maximpinto** · 06-30-2009, 11:00 PM

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

**JBeaucaire** · 06-30-2009, 11:26 PM

You could put a worksheet event macro into the sheet module that keeps redefining a Name Range "Skill" as the text in the active cell.

Please Login or Register  to view this content.

Then use conditional formatting in the table C2:G4

Condition1: Formula Is: =C2=Skill
Format...pattern...yellow

So, whenever the active cell has a value in it that matches values in the table, they will light up.

**maximpinto** · 07-01-2009, 12:38 AM

Dear Jb,
Thanks a ton for your quick response, you made my day
Well what i really liked was regardless of value existing in the whole workbook i can get the cells highlighted
Thanks again
Max

**JBeaucaire** · 07-01-2009, 02:20 AM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)