|
No entry in cell J10 if cell J7 is empty
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 "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 |
Hi
Thanks for the help.. I tried this. .but it did not work.. "Jimbola" wrote in message ... 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 |
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. "KimberlyC" wrote: Hi Thanks for the help.. I tried this. .but it did not work.. "Jimbola" wrote in message ... 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 |
|
In the Data Validation dialog box for cell J10, remove the check mark
for 'Ignore Blank' KimberlyC wrote: Hi Thanks for the help.. I tried this. .but it did not work.. "Jimbola" wrote in message ... 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 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thanks, Debra
Jimbola Don't need the example. Bg "Debra Dalgleish" wrote in message ... In the Data Validation dialog box for cell J10, remove the check mark for 'Ignore Blank' KimberlyC wrote: Hi Thanks for the help.. I tried this. .but it did not work.. "Jimbola" wrote in message ... 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 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Damn your good Debra !
I totally neglected to mention that. "Debra Dalgleish" wrote: In the Data Validation dialog box for cell J10, remove the check mark for 'Ignore Blank' KimberlyC wrote: Hi Thanks for the help.. I tried this. .but it did not work.. "Jimbola" wrote in message ... 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 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| All times are GMT +1. The time now is 02:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com