Results 1 to 2 of 2

Data Validation issue - alert when cell is blank

Threaded View

  1. #1
    Registered User
    Join Date
    09-08-2011
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2007
    Posts
    3

    Data Validation issue - alert when cell is blank

    I'm using 2007. . .

    I'm having trouble with what seems like it should be easy and straight-forward but it's not working like I expect...and internet searches have left me even more confused.

    I simply want to prevent users from leaving cells blanks in cells that contain a defined dropdown list. The dropdown list does not contain any blank cells.

    In the Setting tabs of the Data Validation box:

    I am "allowing" a List
    I have "Ignore Blanks" unchecked
    I have "In-cell dropdown" checked.

    In the Error Alert tab of the Data Validation box:

    I have the "Show error alert...entered" checked.

    Why don't I get the error alert when a cell with a dropdown list designated is left blank.

    Thanks in advance for your help,
    Aaron

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1