data validation

H

Hardy03

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?

I would like B1 to be blank if they put a 0 or 2 in A1
 
H

Hardy03

Had a look at conditional formatting, but doesn't seem to allow you to
constrain a cell to 0,1 and 2 values, also it doesn't help with the showing
of the listbox in B1 (or am i doing something wrong).
Can't access your link
 
Top