Cell restriction

J

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

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 *
 
M

Markv

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
 
D

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

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 *
 
Top