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?