This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello evryone.
I am a new user to excel programming. Can anybody help me to enable/disable a cell that has a dropdown list (created by Data Validation) based on a value in another cell?
The situation is:
A1: Type of Product - Dropdown list with two options
A2: Dropdown list of number of users Product 1
A3: Dropdown list of number of useres Product 2
What i want is depending on the selected product from cell A1, I want to enable the selection in on of the two cells A2 and A3. If product 1 is selected in cell A1 -> A2 is enabled and A3 is disabled and greyed out.
I managed to greyout the cells with conditional formating, but somehow I cannot write a correct formula i data validation that allow me to have a dropdown list AND enable/disable the selection according to another cell.
Any ideas?? I much appreciate your help
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I'd use a drop down list in A2 that is dependent on the product selected in A1, and omit the drop down list in A3.