M
monir
Hello;
a) Cell C7 has a drop-down list of 6 values (data source AJ2:AJ7):
.....3
.....4
.....5
.....6
.....7
.....8
b) I need to impose a restriction on the selection such that:
IF the value in cell Q14 is 19 or 21, THEN the value in C7 should ONLY be 4
IF the value in cell Q14 is 20 or 22, THEN the value in C7 should ONLY be 5
ELSE any selected value from the list is valid.
Is there a way of doing that ??
Your help would be greatly appreciated.
a) Cell C7 has a drop-down list of 6 values (data source AJ2:AJ7):
.....3
.....4
.....5
.....6
.....7
.....8
b) I need to impose a restriction on the selection such that:
IF the value in cell Q14 is 19 or 21, THEN the value in C7 should ONLY be 4
IF the value in cell Q14 is 20 or 22, THEN the value in C7 should ONLY be 5
ELSE any selected value from the list is valid.
Is there a way of doing that ??
Your help would be greatly appreciated.