Frank Freese
asked on
Yes No data validation
Experts,
Can you have a data validation rule that only allows for a Yes or No value
Can you have a data validation rule that only allows for a Yes or No value
Yes you can if you choose 'List' as your allowed values under Data Validation and reference to the cells which contain the 'Yes' and 'No' as your validation list.
Or just enter:
Yes, No
in the Source box.
Yes, No
in the Source box.
ASKER
can it be done w/o a list box with code
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, rorya's solution is the one you want :)
ASKER
is a source box the same as a cell
No, rorya is referring to the 'Source' field within the Data Validation pop up when you choose 'List' from the 'Allow' part.
No - in the Data Validation dialog, change the Allow option to List, then type
Yes, No
in the Source textbox, and uncheck the In-cell dropdown option.
Note: this will be case sensitive so you may want to use a source range instead.
Yes, No
in the Source textbox, and uncheck the In-cell dropdown option.
Note: this will be case sensitive so you may want to use a source range instead.
ASKER
thank you
I think a points split would be fair here as TonyWong's first answer directly addressed your initial question - would you like me to get this reopened so you can reallocate the points?