|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 27th, 2009, 04:23 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional List dropdowns?
Hi, i'm looking to add a condition to certain list drop-down options based
upon the selection in a prior dropdown, is this possible? For example dropdown A, you can select Red, Blue or Green Dropdown B, if they have selected Red - they can choose between Car, Van, Bike. If they have selected Blue then it is Boat, Plane, Walk etc...so the selection choices in dropdown B are contingent on the selection in dropdown A 
|
|
#2
October 27th, 2009, 04:44 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional List dropdowns?
Check out thsi link...
http://www.contextures.com/xlDataVal02.html -- HTH... Jim Thomlinson "GD" wrote: Hi, i'm looking to add a condition to certain list drop-down options based upon the selection in a prior dropdown, is this possible? For example dropdown A, you can select Red, Blue or Green Dropdown B, if they have selected Red - they can choose between Car, Van, Bike. If they have selected Blue then it is Boat, Plane, Walk etc...so the selection choices in dropdown B are contingent on the selection in dropdown A
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
