making a drop down value selectable based on the value selected in another drop down

Rag

New member
Joined
Aug 11, 2020
Messages
2
Reaction score
0
Points
0
Excel Version(s)
Excel 2020
I have a column VR (zusätzl. Verteilerräume) with the selectable values of 1 to 20.
*I also have a column called "Premium" with the values "Yes" and "No" in the drop down.
*So the condition here is as follows:
If the values 1 to 3 are selected in the VR column, then the Premium column can show both "Yes" and "No" as selectable options. However if a value of 4 and above are selected in the VR column, then only the value "Yes" should be selectable in the Premium column.
 

Attachments

  • Unbenannt.PNG
    Unbenannt.PNG
    6 KB · Views: 7
Can someone tell me how I can do this?
 
Back
Top