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. Any idea on how to write a custom data validation formula for this? I don't want to do a drop down list, because I don't want to limit the numbers if J3 says "incremental"
1 Reply
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))
