Lock cells, based upon the input of other cells.

[veer]

Hello,
I am new to this forum and I am really no expert at excell, however I do enjoy just messing around with the various functions and learning more and more.

I am currently studying A-LEVEL Ict and have come accross a problem using excel.

I have created a spreadsheet, Some fields have drop down boxes with one option "Yes". However If "Yes" has been selected in one field I need to lock the rest of that column.

eg. If C5 = Yes, then I need to lock D5,E5,F5,G5 and H5.

Could someone please help me with this, I am really new to this and have not got much knowledge.

Thanks in advance.

[Paul]

Welcome to the forum.

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!