Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I place a condition on a list?
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? |
#2
|
|||
|
|||
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 "Cindy" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to randomly select from a list with condition | Excel Worksheet Functions | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Building list based on condition | Excel Worksheet Functions | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Place a set value in a cell from a drop down list name reference | Excel Worksheet Functions |