Restrict Data Entry to only 4 possible entries

  • Thread starter Thread starter ph8
  • Start date Start date
P

ph8

Hey folks,

Anyone know of a way to restrict data entry in a cell to one of onl
four total possibilities? More specifically, is there a non-vb
solution to restricting users from inputting anything into a cell wit
the exception of:
x X o O

These are lower and upper case of both the letters X and O (not Zer
the Number). The particular range (if it matters) that I need thi
restriction in place is D4:F6.

If you'll notice, the range is a 3x3 square. The charactors in tha
3x3 square have to be either an X or an O (case irrelevent). Yup, yo
know what that means. TicTacToe :)
 
Select D4:F6 and do Data=>Validation

select List

then enter
X,x,O,o

(no double quotes)

Uncheck "incell dropdown" if you don't want the dropdown arrow to appear.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

restricting data entry to non-times 2
data entry restricted to non-times 3
Restricting Cell entry to certain letters 7
Data Entry for 50 Rows only 2
Restrict data entry to specified cells 2
Help With Restricting Values in Data Entry Forms please 1
Restricting data displayed in a subreport to the last x entries 3
Restricting data entry to unique entries only in a specific range 10

Back
Top