data Validation options

[Guest]

I am sorry this may be a bad question, but I am having trouble getting the
data validation option to work the way I would like it to. I have a drop down
box with three selections. I have unchecked the “Ignore Blanks†field. It
still is not giving me any error when I delete the text and chose another
field. If I type anything else it does give me an error. Am I setting
something up wrong or am I mistaken how this works.

 

[Peo Sjoblom]

You are mistaken how it works, you cannot stop someone clearing the contents
of a cell using data validation nor can you stop someone from pasting values
into a cell. The blank part is if you validate one cell for input in
another cell, assume that you want to allow entries in B2 if the contents of
A2 is 10, if you deselect ignore blanks that means that you cannot enter
anything in B2 unless A2 is 10, if you have it checked you can enter
something in B2 if A2 is 10 or if 2 is blank. I think I already told you
this in a an earlier post?

 

[Gord Dibben]

Josh

Not quite clear what you want to happen.

Debra Dalgleish explains DV and errors and ignore blank very well.

http://www.contextures.on.ca/xlDataVal08.html#Invalid


Gord Dibben MS Excel MVP