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

Any problems post back

HTH

J

"KimberlyC" wrote:

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