Data Validation

  • Thread starter Thread starter rocket0612
  • Start date Start date
R

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
 
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.
 
Back
Top