Multiple Dropdown lists Conditional Formatting

S

shift_4

I have five dropdown lists. The selection of the first dd list needs to
determine which one of four dd lists will open next. The first dd list is
always visable. However, the remaining four dd lists must remain hidden until
something is selected in the first dd list. Then only one of the four dd
lists should appear.

I've tried every combination and can't get this to work properly. Any ideas??
 
S

S.Y.M. Wong-A-Ton

Suppose you have dd 1 with the values 1, 2, 3, 4 in it. Add conditional
formatting to dd 2 that says "Hide this control" if "dd1 is not equal to 1".
Add conditional formatting to dd 3 that says "Hide this control" if "dd1 is
not equal to 2". Etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a big matrix in Word 2013 5
Combine Two Different Worksheet_Change codes 9
Multiple Hiding Validation Dropdown Lists 3
Data Validation Error 1
conditional formating dates, please help me 1
Viewing Limited dropdown lists 1
Sort data / items of drop down list 2
Multiple Lists from Unique Data 1

Top