That was exactly the formula I was looking for. Thank you so much!



"Mike H" wrote in message
...
Hi,

Select those cells (say a1 - a100) then use data validation formula

=MOD(A1,12)=0

Mike

"JMM" wrote:

I am creating an order form in which I have cells that are used to enter
a
certain quantity of pencils. The pencils must be ordered in multiples of
12.
How can I use Data Validation to check if the ordered quantity is always
a
multiple of 12?

Thanks,
JM