Data Validation Not Erroring with List

O

OyBouTJ

I have been trying to use the Data Validation to check manually entered data
against a single-column list on another worksheet of the workbook. I can
show it sees the list, since the correct list items show in the drop down.

But the Data Validation does not error when invalid data is manually entered.

The data is text data.
 
T

T. Valko

Select the cell with the validation.

Goto Data>Validation
Select the Error Alert tab
Make sure "Show error alert...." is checked
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

custom data validation on cells with data validation values 2
Data Validation source = destination? 7
Data Validation 1
Problem with data validation 2
In-Cell Drop Down List not properly working 7
data validation 1
How do I create a drop down box within a drop down box? 1
How do I get drop-down list that includes, eg top10 1

Top