Data Validation for Null
 

Hi,
i am new to data validation. I want to create a data validation so that
cells can not be Null. Should I use Custom and if so, how would I write the
formula. What is the best way to accomplish this?

Data Validation for Null
 

Data Validation Custom

first clear the Ignore Blank checkbox
second enter the formula:

=A1<""
for cell A1 for example
--
Gary''s Student
gsnu200709


"Karen" wrote:

Hi,
i am new to data validation. I want to create a data validation so that
cells can not be Null. Should I use Custom and if so, how would I write the
formula. What is the best way to accomplish this?

Data Validation for Null
 

Gary''s Student wrote...
Data Validation Custom

first clear the Ignore Blank checkbox
second enter the formula:

=A1<""
for cell A1 for example
....

That'd prevent editing a cell, clearing its contents while in Edit
mode, then trying to enter the result. It wouldn't prevent clearing
the cell - selecting the cell and pressing the [Delete] key - nor
would it force users to make entries.