Forum Discussion
Solved
How to make a cell either inactive or select from dropdown list depending on a value in another cell
I have a cell where I want the input to be restricted depending on the value in another cell. In this case the restricted value has to be between selecting from a drop down list or make it inactive. ...
See the attached workbook. It is a macro-enabled workbook, so you'll have to allow macros when you open it.
Your description makes partial sense.
A bit confusing is this sentence: Cell A1 is limited to a "Yes" or "No" value basis a drop down list.
Is it Yes or No, and what's the relation to the drop down list? Or is the drop down list just those two possible answers?
Anyway, it is possible to have secondary answers in drop-down (data validation) lists that change based on a primary set of answers to their own drop-down (data validation) lists. I'm attaching a demo file I've created to show how that can work.