Yes and No

[Dragan Ristic]

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

 

[Paul B]

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]

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.

 

[Paul B]

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

 

[Joerg]

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]

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

OK, Thanks.