Conditional Formatting a drop down list

[a02227]

Is it possible to conditionally format based on the selection from a drop
down list. The drop down list has a choice of 18 different status, the user
will select each on depending on what stage of developent a particular case
or client is at. I want to group the status together so if they relate to an
early stage the conditional formatting turns the cell green, middle stage it
turns amber and in the final stage they turn red.

I may not be using the correct method for this so if someone could advise
how I would go about this?

 

[a02227]

Is it possible to conditionally format based on the selection from a drop
down list. The drop down list has a choice of 18 different status, the user
will select each on depending on what stage of developent a particular case
or client is at. I want to group the status together so if they relate to an
early stage the conditional formatting turns the cell green, middle stage it
turns amber and in the final stage they turn red.

I may not be using the correct method for this so if someone could advise
how I would go about this?

I am using Excel 2003

 

[Joerg Mochikun]

Assuming that your dropdown list is in A1 and the list with your 18 stati in
A10:A17.

Conditional format A1 with formula
=AND(MATCH(A1,A10:A27,0)>6,MATCH(A1,A10:A27,0)<13)
If you choose amber, then the 7th to 12th selection from your list will turn
amber.

For selection 1-6 (green) use
=MATCH(A1,A10:A27,0)<7

For selection 13-18 (red) use
=MATCH(A1,A10:A27,0)>12

Cheers,

Joerg