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")
 
Top