+ Reply to Thread
Results 1 to 1 of 1

Excel 2007 : Lock/unlock cells containing drop down validation based results of another drop down

  1. #1
    Registered User
    Join Date
    05-27-2011
    Location
    Leeds, England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Lock/unlock cells containing drop down validation based results of another drop down

    Hello,

    I'm new to the forum so please forgive any lapses in board ettiquette.

    The question is...

    Can I lock/unlock cells that contain drop down data validations based on the result of another drop down validation. And if so how?

    eg - relates to attached file.

    C12 is a drop down. Variables are Select, Yes, No (Select is really just an instruction to users)

    If Yes is selected value I want cells M12:R12 to be unlocked allowing access to the drop downs they contain. Any other result for C12 should leave M12:R12 locked.

    Columns M-R have CountIf functions against the Yes results but I need these only to be returned where C12-22 value = Yes.

    Hopefully the attached file helps to illustrate the problem.

    Any help much appreciated.

    Neil
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1