Forum Discussion
Data Validation Basis Another Cell Inputs
Let's say you want to apply this to B2:B10
Select this range. B2 should be the active cell in the selection.
On the Data tab of the ribbon, select Data Validation.
Select Decimal from the Allow list.
Select between from the Data list.
In the Minimum box, enter the formula
=SWITCH(A2, "A", 100%, "B", 120%, "C", 140%, "D", 160%, "E", 180%)
In the Maximum box, enter the formula
=SWITCH(A2, "A", 120%, "B", 140%, "C", 160%, "D", 180%, "E", 200%)
Adjust the values as needed.
Click OK.
Result:
Let's say you want to apply this to B2:B10
Select this range. B2 should be the active cell in the selection.
On the Data tab of the ribbon, select Data Validation.
Select Decimal from the Allow list.
Select between from the Data list.
In the Minimum box, enter the formula
=SWITCH(A2, "A", 100%, "B", 120%, "C", 140%, "D", 160%, "E", 180%)
In the Maximum box, enter the formula
=SWITCH(A2, "A", 120%, "B", 140%, "C", 160%, "D", 180%, "E", 200%)
Adjust the values as needed.
Click OK.
Result:
