How can I place a condition on a list?

C

Cindy

I have one column that has a list of 3 elements. I want to put a condition
on another column to display a specific drop down list depending on what was
input in the first column. Can I do this?
 
J

jgray

I'm sure this is a more advanced way, but the poor man's solution would be...

with only three elements, you have the ability to use conditional formatting
on the list. I believe excel allows up to three conditions. Just set up the
conditions to be If equals "element a" then this result and repeat for the
next 2. I'm sure there is probably some heavy duty code u could do.. but
this idea is pretty straight forward.

hope it was of some help
 
Top