Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Highlighting fields based on a dropdown in Excel 2003
Hi!
I have a spreadsheet in Excel 2003 that documents some processes that we follow. *1 specifies a number of different processes that we do. A* specifies the different job types that we do. B2:M11 contains some combination of four charcters ("1234") specifying different technologies, based on whether or not the process in (A:*) applies to that technology. For example, if the process in A2 only applies to technology 2 and 4, B2 will contain "24" I'd like to add a dropdown to the sheet containing the four technologies. When a user makes a selection via the dropdown box, I would like to highlight any field on the form containing characters related to that technology. An example: Job A2 uses processes B2 "12" , C2 "124" , F2 "24" Job A3 uses processes C3 "123", D3 "4", G3 "12" Job A4 uses processes C4 "24", D4 "1", E4 "2" ....and the user selects technology 2 from the dropdown. I want the following cells to be highlighted: B2, C2, F2, C3, G3, C4, E4 Is this possible? If so, how? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Populate fields based upon dropdown selection | Excel Discussion (Misc queries) | |||
Highlighting certain fields | Excel Worksheet Functions | |||
populating a dropdown based on choice from a previous dropdown | Excel Programming | |||
highlighting required fields | Excel Worksheet Functions | |||
Number of dropdown fields in Excel is limited. I need more. How? | Excel Discussion (Misc queries) |