No entry in cell J10 if cell J7 is empty

K

KimberlyC

Hi!
Is there a way... using data valadation ...
to not let the user enter any data into cell J10 if cell J7 is empty?


I've played around with it..but not luck yet...

Any help is greatly appreciated!!
Kimberly
 
J

Jimbola

select J10, go to Data Validation.
Select Custom
Enter =NOT(ISBLANK(J7)) as the formula.

Any problems post back

HTH

J
 
J

Jimbola

If you still haven't been able to work this out, give me an e-mail address (1
time offer only) and I will forward you a spreadsheet showing how I did it.
 
D

Debra Dalgleish

In the Data Validation dialog box for cell J10, remove the check mark
for 'Ignore Blank'
 
B

Bg

Thanks, Debra
Jimbola
Don't need the example.
Bg

Debra Dalgleish said:
In the Data Validation dialog box for cell J10, remove the check mark for
'Ignore Blank'
Click to expand...
 
Top