Forum Discussion
Conditional Data Validation
I am trying to do a conditional data validation with the following parameters: If cell J3 reads "replacement", then you can only enter "1", if cell J3 reads "incremental", you can enter any integer. ...
If the data validation is applied to cell K3 then the formula would look like this:
=OR(AND(J3="incremental",MOD(K3,1)=0),AND(J3="replacement",K3=1))