Hello all. I am trying to create a form, and on this form I have an area of dropdown boxes with various options to choose from. What I am trying to do is add a box below the first drop down that the options to choose from are contingent on what you chose in the first drop down box. For instance, lets say the first drop down are colors, red, blue, yellow,green and so on.
Now lets say the drop down below that has options based on the color you chose in that first drop down box. So if I were to choose red, your next options are, deep red, crimson red,scarlet red so on and so on.
But if I would have chosen blue the options instead would be, midnight blue, dark blue,sky blue so on and so on.
I plan on keeping everything on one sheet so there won't be any referencing to another sheet. Any help I would appreciate. I'm pretty descent in excel but this is still a little above what I'm used to doing. I hope i was descriptive enough so that everyone understands my question.
Now lets say the drop down below that has options based on the color you chose in that first drop down box. So if I were to choose red, your next options are, deep red, crimson red,scarlet red so on and so on.
But if I would have chosen blue the options instead would be, midnight blue, dark blue,sky blue so on and so on.
I plan on keeping everything on one sheet so there won't be any referencing to another sheet. Any help I would appreciate. I'm pretty descent in excel but this is still a little above what I'm used to doing. I hope i was descriptive enough so that everyone understands my question.
