Results 1 to 4 of 4

Thread: Post how to disable cells if selecting a value using drop down

  1. #1

    Post Post how to disable cells if selecting a value using drop down



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I have two values (Yes and No) in a drop down in A1. If i select yes then only cells (B1 to G1) should be disbaled. i.e. no one can select cells (B1 to G1) or make non editable cells. If i select No then these cells (B1 to G1) should be editable or selectable.

  2. #2
    You could add data validation to B1:G1 with a type of Custom and a formula of =$A$1<>"yes"

  3. #3
    Quote Originally Posted by Bob Phillips View Post
    You could add data validation to B1:G1 with a type of Custom and a formula of =$A$1<>"yes"

    Thanks bob,

    above formula not working

  4. #4
    I think you need to be more specific.

Posting Permissions

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