| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
|
#7
|
|||
|
|||
|
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 |
|
#8
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is statement with an empty cell as result | Excel Worksheet Functions | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
Hybrid Mode
