Hi,

I am using list validation in column A where user can choose 1-9 in each
cell. What I wish to create is:

if A1=1 then the validation list for B1 is 1.1 to 1.9
if A1=2 then the validation list for B1 is 2.1 to 2.9

and so on.... In effect, its conditional which validation list is being used.

How do I set this up??

Thanks in advance
Robert