Data validation for 2 valid values

  • Thread starter Thread starter Hall
  • Start date Start date
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?
 
Data>validation>allow>list, put the 2 values separated by a comma in the
source box, uncheck in cell dropdown
 
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")
 
You must log in or register to reply here.

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

Turning on data validation in one cell based on the contents ofanother cell 1
data validation list 17
Need help with Data Validation Formula for a set of numerical andtext-based values 7
Data Validation 1
Data validation error with multiple CPU 1
VLookup not working - missing entries or not returning correct values 1
Selective data validation list 1
If formula and Data Validation parallely 1

Back
Top