 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / October 2006Yes and No
Please help, I need a formula for data validation that accept only "Yes" and "No" values. Thanks. Dragan, data validation, allow, list, source Yes, No is that what you want?  SignaturePaul 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 > Please help, > I need a formula for data validation that accept only "Yes" and "No" > values. Thanks. > 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. 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? SignaturePaul 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, 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. 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, 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. > 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 => [quoted text clipped - 11 lines] >> in cell Yes or No value. >> Sorry on my bad English. OK, Thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.