Data Validation for Null

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karen - 07 Mar 2007 16:36 GMT

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?

Reply to this Message

Gary''s Student - 07 Mar 2007 18:04 GMT

Data > Validation > Custom

first clear the Ignore Blank checkbox
second enter the formula:

=A1<>""
for cell A1 for example

Signature

Gary''s Student
gsnu200709

> 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?

Reply to this Message

Harlan Grove - 07 Mar 2007 18:27 GMT

Gary''s Student <GarysStud...@discussions.microsoft.com> wrote...

>Data > Validation > Custom
>
[quoted text clipped - 3 lines]
>=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.

Reply to this Message