Data Validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In cell A1 users are required to enter either 0,1 or 2. Firstly how do I make
this cell only accept these values and secondly, if they enter 1 (not 0 or 2)
I need B1 to become a listbox, listing two options.
Can anyone help please
 
What do you want to happen to B1 if, after the list box is created, th
user changes the value in A1 to either 0 or 2? Remove the list box
change the values or just leave it alone
 
You must log in or register to reply here.

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

data validation 3
Data Validation - Prevent delete 2
A data validation question 1
Data Validation - Preventing Delete from Delete Key 2
Validate entry based on another cell value 6
multiple data validation 3
Excel 2007 3
Validation 4

Back
Top