Activate or Deactivate a cell

[aronyo]

Hello

I am trying to make a spreadsheet with an option of activated cells. Say, if I select YES in A1 cell (which is limited by YES and NO with data validation), the B1 will be activated to enter data. But I select the NO option, the B1 cell will remain deactivated and data cannot be entered into the B1 cell.

Can anyone please suggest a less complicated way ?

[dangelor]

Try setting a custom validation for B1, using the formula

=$A$1="YES"

[aronyo]

Thank you for your help.

As i have mentioned earlier, I want this B1 cell will be activated only when YES is selected in A1 cell. But the B1 is suppose to have an another Data Validation Rule with a small list of AGENT & DIRECT. So how to combine the both Data Validation rules ?

Thanks again for your support.

[dangelor]

aronyo,

To make the second list dependent on the first, create a named range named "YES" and have it include AGENT and DIRECT. Then use this formula as the List validation for the second list, changing $A$1 if it's not your first list location.

=INDIRECT(SUBSTITUTE($A$1," ","_"))

HTH,
Rich

[Winon]

Hello aronyo,

What dangelor gave you works fine. If you don't want to use Named Ranges, you could use this Formula in your Data Validation. First enter Yes in Cell A1, and then go to Cell B1 to enter the Data Validation Formula.

Please Login or Register  to view this content.

For the purpose of this exercise I have assumed that your Data Validation List for B1 would be in Column B, Cells 9 down to 11.

Good Luck!

[aronyo]

Thanks a lot. It solved my problem.