PDA

View Full Version : Solved: Data Validation



gimli
12-09-2010, 06:41 AM
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
12-09-2010, 06:45 AM
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
12-09-2010, 12:12 PM
You make it all to easy

thanks much