Mar 27 2019 07:52 AM
Hello,
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?
Thank you!
Mar 27 2019 08:58 AM
You could add a total/sum cell somewhere on the sheet and light up A1 using Conditional formatting if the total/sum of B1:B5 doesn't match the value in A1.
Step 1: Add the helper cell.
Step 2: Add the Conditional Formatting Rule
Mar 27 2019 10:16 AM
SolutionMar 27 2019 11:32 AM
This works great, I was way overthinking it. Thank you for the help!!
Mar 27 2019 11:56 AM
Mar 27 2019 10:16 AM
Solution