Data Validation

[rocket0612]

Is there a way to disallow a blank entry on a cells with dat
validation. I want a data validation that will only allow you to selec
‘YES’ or ‘NO’ from a drop down menu. All cells C1:C1000 will b
defaulted to ‘NO’. I don’t want the cell to be able to be blank as i
messes up formulas I have.

thank

 

[Debra Dalgleish]

Data validation allows you to clear the cell by pressing the delete key,
so you can't use it to prevent users from leaving the cell blank.

You could change your formulas to treat a blank cell like No, or use
programming to prevent blank cells.