I have a sheet that has 'Yes/No' dropbox cells in it.
Altough I do not want these cells fully protected (as the user will need the ability to select the yes/no options) I do want to protect these cells against any alternative information being entered.

I have validation so it is not possible for the user to type any info into the cells however it is possible for the user to paste info in. Is there anyway to protect against this while still keeping the yes/no dropdown available to the user?