Data Validate to Even Numbers

[HardyRexion]

Hello

I'm sure this is an easy one for most of you but can I use Data Validation to only allow even numbers in my cells

Thank you

[DonkeyOte]

You can apply a Custom Rule of:

Please Login or Register  to view this content.

where A1 is the "active" cell when the validation is first set

edit: in reality the ISNUMBER test isn't required... =MOD(A1,2)=0 would suffice.

[johnjohns]

This can be one way

[HardyRexion]

Thank you. Job done. Wasn't aware of the Mod function