I am having trouble figuring this out, I'm not sure if it is even possible. So I have a range of cells that a customer will be inputting data, this data must meet a full container quantity. So lets say A1 has a 10 pc box quantity, then whatever number they input in B1:B5 has to be divisible by 10. Is there anyway to make this automatically happen or maybe make a prompt letting them know that the number they entered is not divisible by what is in A1?
Use custom this data validation formula in B1:B5, with B1 selected: =MOD(B1,A$1)=0 This may be your input message: Enter a number divisible by the number in A1. Lastly, this may be your error message: The number you entered is not divisible by the number in A1. Please enter another number.