No entry in cell J10 if cell J7 is empty

  • Thread starter Thread starter KimberlyC
  • Start date Start date
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
 
select J10, go to Data Validation.
Select Custom
Enter =NOT(ISBLANK(J7)) as the formula.

Any problems post back

HTH

J
 
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.
 
Looks like something I can use. Would you mind sending it me, also?
(e-mail address removed)

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation - Complex Q 2
Leave "formula cell J7" empty until H7 has a date. 2
Not allowing users to enter data into certain cells if another cell is empty 12
Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA) 7
Need help Taking alot data from one sheet (if not blank) and copying toa list on another sheet. 1
Data Valadation - 1
should I use IF function? 2
Data Valadation help 2

Back
Top