Limit an Excel cell to one of two possible values

Question

I would like to create a cell format for one cell to only allow the value "yes" or "no" for this cell.

How could I do this?

Answer 1

Microsoft describes this here: Apply data validation to cells

1. Click the cell you want to restrict value for
2. Go to Data -> Validation. The Data Validation dialog box opens
3. In the Allow dropdown select List

4. In the Source text box enter Yes,No

   Note: This will also work for more than two possible options; simply separate additional desired options with a comma.

Now your cell will have a dropdown with Yes and No. The user can also type these values without clicking the dropdown button.