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.
*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.