No entry in cell J10 if cell J7 is empty

[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

 

[Jimbola]

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

Any problems post back

HTH

J

 

[KimberlyC]

Hi
Thanks for the help..
I tried this. .but it did not work..

 

[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.

 

[Bob G]

Looks like something I can use. Would you mind sending it me, also?
(e-mail address removed)

Bg

 

[Debra Dalgleish]

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

 

[Bg]

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

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

 

[Jimbola]

Damn your good Debra !
I totally neglected to mention that.