Cell restriction

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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 *
 
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
 
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.)
 
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 *
 
Back
Top