Yes and No
 

Please help,
I need a formula for data validation that accept only "Yes" and "No"
values. Thanks.

Yes and No
 

Dragan, data validation, allow, list, source Yes, No is that what you want?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Dragan Ristic" wrote in message
...
Please help,
I need a formula for data validation that accept only "Yes" and "No"
values. Thanks.

Yes and No
 

Paul B wrote:
Dragan, data validation, allow, list, source Yes, No is that what you want?
No, I don't need list. Only I want validation that allow user to input
in cell Yes or No value.
Sorry on my bad English.

Yes and No
 

Dragan, that will only allow yes an no to be put in the cell, could you
explain a little more about what you want to do?

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Dragan Ristic" wrote in message
...
Paul B wrote:
Dragan, data validation, allow, list, source Yes, No is that what you
want?
No, I don't need list. Only I want validation that allow user to input
in cell Yes or No value.
Sorry on my bad English.

Yes and No
 

Dragan, you already have a list:Yes and No. These are 2 values, Excel
regards this as a list. Try to follow Paul's advice and use Data =
Validation =Settings. In the 'Allow' box, choose 'List'. You will see a box
called "source'. Directly input into this box all values that you want to
allow, separated by commas, e.g Yes,No

Cheers,

Joerg

"Dragan Ristic" wrote in message
...
Paul B wrote:
Dragan, data validation, allow, list, source Yes, No is that what you
want?
No, I don't need list. Only I want validation that allow user to input
in cell Yes or No value.
Sorry on my bad English.

Yes and No
 

Joerg wrote:
Dragan, you already have a list:Yes and No. These are 2 values, Excel
regards this as a list. Try to follow Paul's advice and use Data =
Validation =Settings. In the 'Allow' box, choose 'List'. You will see a box
called "source'. Directly input into this box all values that you want to
allow, separated by commas, e.g Yes,No

Cheers,

Joerg

"Dragan Ristic" wrote in message
...
Paul B wrote:
Dragan, data validation, allow, list, source Yes, No is that what you
want?
No, I don't need list. Only I want validation that allow user to input
in cell Yes or No value.
Sorry on my bad English.


OK, Thanks.