Data validation

[paroduso]

Hi everyone...i need help with data validation...

How to restrict value entry/input in a cell based on another cell value in Excel?

ExtendOffice provides a comprehensive range of professional software solutions, enhancing productivity and efficiency for businesses worldwide.

www.extendoffice.com

On this page i have the answer to my question but i need an update...witch is...i need a second "if"...in the example if i type "yes" on cell A1 the specified range cells are allowed to input data but i need to type for example also "no"...so both of them will work "yes" and "no"...two conditions.

Tank you all.

 

[mikerickson]

You can do that with two named ranges, ListYes and ListNo. Set Validation to List and set the source as =IF($A$1="Yes", ListYes, ListNo)

 

[paroduso]

You can do that with two named ranges, ListYes and ListNo. Set Validation to List and set the source as =IF($A$1="Yes", ListYes, ListNo)

You can do that with two named ranges, ListYes and ListNo. Set Validation to List and set the source as =IF($A$1="Yes", ListYes, ListNo)

Hi mikerickson...that works fine...but i need only one range and when i type "yes" or "no" in cell a1 the specified range cells are allowed to input data. Thanks.???

 

[mikerickson]

I'm not sure what the question is.
You have A1 with either Yes or No

Are you trying to trying to allow the user to enter data in one range if A1 is Yes and not in the another.
And if No is in A1, the user can't enter data into that first range, but only into the second.

A formula like =($A$1="YES") on the cells fo the first range, with the DV formula =($A$1="NO") in the second would do that.

 

[paroduso]

I'm not sure what the question is.
You have A1 with either Yes or No

Are you trying to trying to allow the user to enter data in one range if A1 is Yes and not in the another.
And if No is in A1, the user can't enter data into that first range, but only into the second.

A formula like =($A$1="YES") on the cells fo the first range, with the DV formula =($A$1="NO") in the second would do that.

Hi...let me see if i can explain?

I have cell A1 with "yes" or "no" doesnt metter...the range is "C1:C10"...now...if cell A1 is "yes" or "no" users can edit that range from C1:C10 if not they receid the validation error message.

 

[mikerickson]

That's what the Data Validation formula I posted would do.
Select C1:C10 and set Validation to allow data entry when =($A$1="Yes")

 

[paroduso]

sometimes we make difficult what is simple...

=OR($A$1="yes";$A$1="no")

done ???