Custom Data Validation : Lock if MyCell = ""?
 

I am trying to use a custom data validation formula to prevent entry in a
cell if another cell is blank.

If I enter:
=ISBLANK($G$51)
I get the opposite of what I want... Cell G51 is blank and I do not want the
user to be able to enter data in the cell I am using validation on.

If I enter:
=(NOT(ISBLANK($G$51))
The user can enter data into the cell I am using validation on regardless of
if there is data in it or not!

I am using Excel 2003 SP3.

Not sure what's up with this and couldn't find a similar post... I
appreciate any insight!

Later-
Ray

Custom Data Validation : Lock if MyCell = ""?
 

Use

=$G$51<""



and make sure you clear the "Ignore Blank" checkbox



--


Regards,


Peo Sjoblom


"RayportingMonkey" wrote in
message ...
I am trying to use a custom data validation formula to prevent entry in a
cell if another cell is blank.

If I enter:
=ISBLANK($G$51)
I get the opposite of what I want... Cell G51 is blank and I do not want
the
user to be able to enter data in the cell I am using validation on.

If I enter:
=(NOT(ISBLANK($G$51))
The user can enter data into the cell I am using validation on regardless
of
if there is data in it or not!

I am using Excel 2003 SP3.

Not sure what's up with this and couldn't find a similar post... I
appreciate any insight!

Later-
Ray

Custom Data Validation : Lock if MyCell = ""?
 

Try this:

=LEN($G$51)

Uncheck Ignore blank

--
Biff
Microsoft Excel MVP


"RayportingMonkey" wrote in
message ...
I am trying to use a custom data validation formula to prevent entry in a
cell if another cell is blank.

If I enter:
=ISBLANK($G$51)
I get the opposite of what I want... Cell G51 is blank and I do not want
the
user to be able to enter data in the cell I am using validation on.

If I enter:
=(NOT(ISBLANK($G$51))
The user can enter data into the cell I am using validation on regardless
of
if there is data in it or not!

I am using Excel 2003 SP3.

Not sure what's up with this and couldn't find a similar post... I
appreciate any insight!

Later-
Ray

Custom Data Validation : Lock if MyCell = ""?
 

Try:-

=ISBLANK($G$51)=FALSE

Regards,

OssieMac

"RayportingMonkey" wrote:

I am trying to use a custom data validation formula to prevent entry in a
cell if another cell is blank.

If I enter:
=ISBLANK($G$51)
I get the opposite of what I want... Cell G51 is blank and I do not want the
user to be able to enter data in the cell I am using validation on.

If I enter:
=(NOT(ISBLANK($G$51))
The user can enter data into the cell I am using validation on regardless of
if there is data in it or not!

I am using Excel 2003 SP3.

Not sure what's up with this and couldn't find a similar post... I
appreciate any insight!

Later-
Ray

Custom Data Validation : Lock if MyCell = ""?
 

I should have also said to ensure that you uncheck Ignore Blank.

Regards,

OssieMac

"RayportingMonkey" wrote:

I am trying to use a custom data validation formula to prevent entry in a
cell if another cell is blank.

If I enter:
=ISBLANK($G$51)
I get the opposite of what I want... Cell G51 is blank and I do not want the
user to be able to enter data in the cell I am using validation on.

If I enter:
=(NOT(ISBLANK($G$51))
The user can enter data into the cell I am using validation on regardless of
if there is data in it or not!

I am using Excel 2003 SP3.

Not sure what's up with this and couldn't find a similar post... I
appreciate any insight!

Later-
Ray

Custom Data Validation : Lock if MyCell = ""?
 

Thanks for the responses - It looks like the key factor was the "Ignore
Blank" checkbox - Crisis Averted...