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?
Microsoft describes this here: Apply data validation to cells
Click the cell you want to restrict value for
Go to Data -> Validation. The Data Validation dialog box opens
In the Allow dropdown select List
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.