multiple data validation lists for one cell

Posted by Kevin on January 14, 2002 2:04 PM

Is it possible to have a data validation list for a cell contain data that changes based on what you enter in another cell?

Thanks,
Kevin

Posted by Jacob on January 14, 2002 2:22 PM

Sure its possible let say the validation is in z1:z100 those cells (z1:z100) can have anything in them even a function like =if(whatever) the result will be what is used in the validation. The draw back... if the data changes the old data that was previously enterred that is now invalid will not be changed. So if for example 5 is a valid input and you input 5 then later 5 is nolonger valid, well the 5 you already inputted will stay there.

HTH

Jacob