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.