I'm creating an excel calculator and i need the user to select inputs from a number of fields before the calculation is run. Depending on what the user selects i need secondary cells to display different options. In this case:
I have a cell with a dropdown which is either Yes or No.
If the user selects "Yes" in cell A1 then i want cell B1 to have a dropdown for "Plan 1" and "Plan 2" available.
If the user selects "No" from cell A1 dropdown i'd like cell B2 to be un-editable, or failing that, display something like "N/A"
Is that possible?
Thanks,
Jack
Bookmarks