Yes No in a cell with yes shown unless changed to no

Hello Brian1968 ,

It is very simple to create dropdown list. File is attached with an example for you.

Step 1 Select Cells where you want to create dropdown list
Step 2 Go to Data Tab -> Select Data Validation
Step 3 Select List in Allow Section
Step 4 Select Source Cells

*You can select one cell than expand the list by dragging like any other formula.

I hope it will help you.

Thanks.