Thanks Tom!

It worked for me too.

"Tom Ogilvy" wrote in message
...
go to the namebox and type in

J9:J1000 and hit enter (this select J9 to J1000 so you can apply the
validation all at once).

then do Data=Validation and select custom.

Put in the formula

=LEN(TRIM($J$7))<0 (use the absolute reference for $J$7

** Uncheck the Ignore Blank check box **

click OK.

This worked for me.

--
Regards,
Tom Ogilvy

"KimberlyC" wrote in message
...
I used this formula in cell J9
=NOT(ISBLANK(J7))

"Tom Ogilvy" wrote in message
...
Data validation should work. What formula did you use?

--
Regards,
Tom Ogilvy

"KimberlyC" wrote in message
...
Hi,

I would like to NOT allow the user to enter any data into cells
J9:J1000 if cell J7 is empty and
K9:K1000 if K7 is empty and
L9:L1000 if L7 is empty and
M9:M1000 if M7 is empty and
N9:N1000 if N7 is empty and
O9:O1000 if O7 is empty and
All the way to
AG9:AG1000 if AG7 is empty

I was thinking I could do this with data valadation..but I could not
get
that to work.

Maybe this can be done with VBA??

Any help is greatly appreciated.

Thanks,
Kimberly