Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 17th 05, 07:15 PM
renee
 
Posts: n/a
Default How do i set up data validation to only enter yes or no?

I need to know how to set up data validation that only allows the user to
type y or n in a cell.

  #2   Report Post  
Old October 17th 05, 07:21 PM
Anne Troy
 
Posts: n/a
Default How do i set up data validation to only enter yes or no?

Select cell(s). From the menu, choose Data--Validation, choose List, type
in the box: yes,no
That's it!
************
Anne Troy
www.OfficeArticles.com

"renee" wrote in message
...
I need to know how to set up data validation that only allows the user to
type y or n in a cell.



  #3   Report Post  
Old October 18th 05, 01:31 PM
Debra Dalgleish
 
Posts: n/a
Default How do i set up data validation to only enter yes or no?

You can use data validation to limit what a user can type in a cell. The
data validation can refer to a list on a worksheet, or to a list that
you type in the data validation dialog box. There are instructions here
for using a list on the worksheet:

http://www.contextures.com/xlDataVal01.html

Note: if you type the list in the data validation dialog box, it is case
sensitive. For example, if your list is "y,n", users will be able to
enter lower case y or n, but not upper case Y or N.

renee wrote:
I need to know how to set up data validation that only allows the user to
type y or n in a cell.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Case Sensitivity problem with data validation Upya Excel Worksheet Functions 3 October 7th 05 01:30 AM
data validation lists [email protected] Excel Discussion (Misc queries) 5 June 25th 05 07:44 PM
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM
Effect of Conditional Formatting, Data Validation Bill Sturdevant Excel Discussion (Misc queries) 1 January 25th 05 11:50 PM
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? Arvi Laanemets Excel Discussion (Misc queries) 0 December 2nd 04 11:29 AM


All times are GMT +1. The time now is 04:51 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017