Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting a drop down list
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting a drop down list
"a02227" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting a drop down list
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 "a02227" wrote in message ... "a02227" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Drop Down List | Excel Discussion (Misc queries) | |||
Drop Down Menu Conditional Formatting | Excel Discussion (Misc queries) | |||
Formatting (conditional?) a drop down box selection | Excel Discussion (Misc queries) | |||
Conditional drop down list | Excel Discussion (Misc queries) | |||
How do i set up conditional drop-down list | New Users to Excel |