my validation criterias for the cell are:
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!