Cell restriction

[Guest]

How can I restrict a cell to only accept a "Yes" or 'No" input?

 

[JulieD]

click on cell
choose data validation
under the settings tab
choose List
in the big white box down the bottom type
yes,no
click on the Ok button

 

[A.W.J. Ales]

Mark,

Data / Validation / Setting tab ; Allow dropdownbox : List ; Source :
Yes,No

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Guest]

Julie
When I enter another value it will accept that val;u
How do I make the cell only accept either a Yes or No

----- JulieD wrote: ----

click on cel
choose data validatio
under the settings ta
choose Lis
in the big white box down the bottom typ
yes,n
click on the Ok butto

 

[Dave Peterson]

The only way I could get JulieD's technique to allow other values was to change
a setting on the "Error Alert" tab of the Data|validation dialog box.

How did you do the Data|validation and how did you put the other value in the
cell?

(Pasting to this cell breaks Data|Validation, too.)

 

[A.W.J. Ales]

Mark,

It shouldn't accept any input other than yes or no.

Is in the same dialog (Data / Validation, but on the "Error Alert" tab) the
Style textbox filled with Stop ?
And is the "Show error alert" option box checked ?

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *