Locking cells

[EDMONd]

I am trying to lock cells E10-E40 untill cell J4 has an entry greater than 3. I sure could use some help.
Thanks
EDMONd

 

[EDMONd]

There is not a formula or formatting in J4.
EDMONd

 

[erik.van.geit]

Edmond,

It should be good if you could explain

what you already have on your sheet
if you understand what I wrote (Thu Jan 20, 2005 12:07 am ) and if you tried it

(at the moment forget about VBE, till TAZ is again online, it is confusing to mix up things now)

kind regards,
Erik
(online for another 15 minutes)

 

[EDMONd]

Is there a way to post my worksheet?
EDMONd

 

[EDMONd]

Your suggestion of validation results in a true/false outcome. I also need the cells to be blank so info can be entered. My goal is to require an entry in J4 before entries can be made in E10-E40.
Thank you for your help
EDMONd

 

[erik.van.geit]

Yeh!
You can post within your thread a "screenshot" Using Colo's HTML Maker utility for displaying your Excel Worksheet on the board which you find on the bottom of the page.
But for this easy question I don't see why you would do that.
The user may not fill in cells E10 to E40 when J4 isn't higher then 3.
You can "tell" this to those cells (E10-E40) using validation as explained in my first post.

We really want to help you, but then you need to anwer some questions.
Did you try what I suggested? Do you need more clarification?

kind regards,
Erik

 

[EDMONd]

I did enter =$J$4>3 as you suggested. It results in true/false. It doesnt seem to stop entries.
EDMONd

 

[erik.van.geit]

I didn't see your last post before sending mine.

you said

Your suggestion of validation results in a true/false outcome.

my suggestion results in the fact that you can't input information in those cells until cell J4 > 3
but you can delete contents of those cells

I also need the cells to be blank so info can be entered.

I don't understand this.

My goal is to require an entry in J4 before entries can be made in E10-E40.

that goal seems achieved for me, since you can't fill in E10-E40 without entry in J4

itwill cost us an effort to come closer, but we'll find a way...
Erik

 

[erik.van.geit]

I did enter =$J$4>3 as you suggested. It results in true/false. It doesnt seem to stop entries.

OK, we're getting closer if you pay attention now
You entered the formula right in the cells instead of in the validationbox

select your range E10-E40
go to menu data: in that menu select validation
choose custom in the dorpdownlist
type in the formulabox which is part of the validationbox: =$J$4>3

OK?

you'll succeed
you're close!
Erik

 

[EDMONd]

I have been paying attention, I did exactly what you said. data can still be entered in E10-E40 without J4 having an entry in it.
Thanks for your help
EDMONd

 

[EDMONd]

I found my error. I needed to uncheck the ignore blank block.
Again, Many thanks
EDMONd