Data validation for 2 valid values

H

Hall

I want a cell to allow only 2 valid values but not have a drop-down list
appear.

How do I do that with Data->Validation?
 
P

Peo Sjoblom

Data>validation>allow>list, put the 2 values separated by a comma in the
source box, uncheck in cell dropdown
 
D

Debra Dalgleish

Using a list, as Peo suggested, will force users to match the case used
in the list. For example, if the List is "Yes,No", you won't be able to
enter yes, or YES.

Another option is to Allow: Custom, and in the formula box, use an OR
formula to list the options. If the data validation is in cell D4 --

=OR(D4="Yes",D4="No")
 

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

Need help with Data Validation Formula for a set of numerical andtext-based values 7
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Data validation error with multiple CPU 3
Turning on data validation in one cell based on the contents ofanother cell 1
Data Validation 1
Combo box 0
Data Validation List (conditional) 2
Data Validation List controlled by Cell Value 6

Top