Select all the cells you want to have this functionality and note which cell
in the selection remains active (it will be the cell that is white, that is,
non-shaded). Click Data/Validation on Excel's menu bar, select "Custom" in
the "Allow" drop down box and put this formula in the "Formula" field...

=MOD(A1,4)=0

Substitute the address for the active cell from your selection in place of
the example A1 that I used in the above formula and make sure the "Ignore
blank" checkbox has a check mark in it. You can show a message when one of
the cells is selected by the user (see Input Message tab) if desired and you
can customize its message as well as the message when an incorrect entry is
inputted (see the Error Alert tab) or use the system's default message (your
choice). Click OK when you are done and the cells you initially highlighted
will now only allow a type in that is a multiple of 4.

--
Rick (MVP - Excel)


"Liz S." <Liz wrote in message
...
Can I set up a conditional response that posts a false message if the user
enters a value that is not divisable by 4?

I am creating a cost calulator and the user must enter a number of pages
but
the number of pages must be a multilpe of 4. Minimun answer is 4.