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?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
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
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
No. The user can also type these values without clicking the dropdown button.