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