Desperate Help needed with Locking out a range of cells based on selection from 1 cell

Apologies but I am self taught on Excel and have reached the limit of my abilities!! I have created a spreadsheet that has a range of cells with drop down lists. What I want to do is lock out a series of cells based on the choice made in one cell. I have looked at the threads on the site but have no knowledge what so ever of Visual Basic and therefore the coding means nothing to me. What I need help with is the following.

Cell Y15 (Drop down list choices of Y or N). When N is chosen I want the adjacent cells of Z15 to AF 15 to lock so that nothing can be entered. These have drop down menus as well as they need to be completed if Y15 has Y chosen from the drop down list.

I am using Excel 2010 and really need the 'idiots' guide to how to either create a formula or to do what is need to enable me to sort this out and then to be able to replicate it for other parts of the workbook.

I am now at my wits end...so any help or advice would be really appreciated

Vcummi,

Try this:

Please Login or Register  to view this content.

Hiya

Not sure how to try it. Do I need to insert the code somewhere? Sorry it that's really basic but I am learning as I go!

Sorry, again I am completely lost? In my column Y15 I have put in drop down box that contains Y or N. If a person chooses N here then I want the next columns (Z15 to AF15 to lock so that nothing can be filled in using the drop down boxes specific to those cells.

I am therefore not sure what you mean by V11 and V12? And even more basic than that....how do U use data validation to enter that forumula.....what do I choose under settings on that tab?

I really am sorry for this but I am struggling.

Thanks for your help

Val

Many thanks I will have a look and come back to you. I am not sure what you need me to do with regards to the last sentence? Sorry!

Thanks everyone I think have cracked it now....if it hasn't 'cracked' me!! No doubt I will be back again, but in the meantime all the help has been really appreciated.

Val