Custom Validation
 

my validation criterias for the cell a
input must be divisble to 4 and larger than 100

I can only use = Mod(A1, 4)=0 , but not able to set the 2nd criteria in one
cell.
Would anyone know the way to fulfill both?
thx!

=AND(MOD(A1,4)=0,A1100)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"kalz" wrote in message
...
my validation criterias for the cell a
input must be divisble to 4 and larger than 100

I can only use = Mod(A1, 4)=0 , but not able to set the 2nd criteria in
one
cell.
Would anyone know the way to fulfill both?
thx!