Solved: Data Validation

[gimli]

Hi all,

Looking for ideas...

I have a cell that has numeric data validation so only values between 0 and 2 are allowable.

I would like to change that conditon to 0-1 base on the value of another cell.

Ex

If A1 = 1 I would like cell A2 numberic data validation to be 0-1

all other values I would like it to be 0-2

any ideas would be great

thanks

[Bob Phillips]

Use a DV type of custom and a formula of =OR(AND(A1=1,A2>=0,A2<=1),AND(A1<>1,A2>=0,A2<=2))

[gimli]

You make it all to easy

thanks much