Operator error I am sure,but I am unable to get data validation to function
correctly. It is a simple list (yes,no from a 2 cell named range), ignore
blank is not checked. I want an error if the user does not make a selection.
The show error box is checked. BUT, if the field is left blank, the message
does not show up. (Just as a check I type something else in the field and
the message does show up). What have I done wrong? Thank you.