Data Validation Question

B

Bob Myers

I'm looking for a custom formula for data validation in a cell. The user is
to be allowed to enter either Yes or No in accordance with the following
logic:

If (True, "No", Or("Yes", "No")) {If a condition is True, he can't do
it; otherwise, he has a choice.}

Respectfully submitted,
Bob Myers
 
T

T. Valko

You should have told us what the condition is.

This will allow only No in B1 if the logical test is TRUE. If the logical
test is FALSE then it will allow only Yes or No.

=IF(logical_test,B1="No",OR(B1="Yes",B1="No"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

custom data validation on cells with data validation values 2
Tough Question 3
Usage of Data Validation with If Condition 4
Data consistency 1
Multiple data validation criteria? 1
Data validation for specific text, for example "blue"? 1
Data Validation, Custom 1
Data Validation 1

Top