Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight the cell based on selected value
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight the cell based on selected value
Hi,
No doubt this can be done but we need to see some dummy data with the explanation to match that example. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Max" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight the cell based on selected value
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 "Shane Devenshire" wrote: Hi, No doubt this can be done but we need to see some dummy data with the explanation to match that example. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Max" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight duplicate cells based on a selected cell | Excel Discussion (Misc queries) | |||
Highlight duplicate cells based on a selected cell | Excel Discussion (Misc queries) | |||
Cell won't highlight when selected | Excel Discussion (Misc queries) | |||
How do I have a cell highlight when selected? | Excel Worksheet Functions | |||
How do I have a cell highlight when selected? | Excel Discussion (Misc queries) |