Data Validation

  • Thread starter Thread starter Alex H
  • Start date Start date
A

Alex H

Hi

I have some cells which validate to ensure that users dont enter a value of
more than 5. This works Ok until users in clearing the contents, use the
space bar and not the clear content function.

Is there a way i can validate data to allow either cell = null, blank or
anything up to 5.

Thanks

Alex
 
Tell the user not to do that, it is like typing text into a cell, clear the
cell
using the menu or record a macro clearing the cell and attach the macro to a
button
you call Clear. Otherwise I assume something like this will work using
custom under the validation menu

=AND(B1<=5,B1=" ")
 
Thanks a lo Peo

I do tell them that, but who am I a mere IT techie...

I sometimes would like to pop up a big sign saying DUMMY when they do that

Alex
 
LOL - yes I saw that one !

Cheers

Alex


Peo Sjoblom said:
Sorry, wrong formula,

=OR(B1<=5,B1=" ")

where B1 is the cell with validation

--

Regards,

Peo Sjoblom


macro blank
Click to expand...
 
Back
Top