I have a cell with a Data Validation with a list having the Source as a named range on the worksheet. However, if I blank out the cell, it is accepted. I tried selecting the 'IGNORE BLANK' button on the Data Validation form and unselecting it. Nothing works. How can I get this cell to reject a blank input and only allow the listed items?
Second, This source list is selected with an '=INDIRECT(A17)' statement. If A17 is changed, how can I blank out this cell(D17), thus forcing the person to select a valid input from the new list, considering the fact, the list will not accept a blank input if I can get an answer to my first question.
Second, This source list is selected with an '=INDIRECT(A17)' statement. If A17 is changed, how can I blank out this cell(D17), thus forcing the person to select a valid input from the new list, considering the fact, the list will not accept a blank input if I can get an answer to my first question.