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
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