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? |
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 |
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 |
All times are GMT +1. The time now is 08:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com