I have validation in one cell based on a value in an adjacent cell i.e. user selects "numbers" in cell A1 and the choices in A2 are "1","2" and "3", user selects "letters" in cell A1 and the choices in A2 are now "a","b" and "c".
The only problem is that, having made a selection in cell A2, if the user then goes back and changes cell A1, A2 retains the same (now invalid) value.
I am using Excel's standard cell validation - is there any way I can better link the 2 cells or trap the fact that the value in A1 has changed and at least clear the value from A2?
The only problem is that, having made a selection in cell A2, if the user then goes back and changes cell A1, A2 retains the same (now invalid) value.
I am using Excel's standard cell validation - is there any way I can better link the 2 cells or trap the fact that the value in A1 has changed and at least clear the value from A2?
