Limit an Excel cell to one of two possible values

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?

1 Answer

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.