Dependent data validation list

Hi,

The cells in column B in my spreadsheet can only contain numeric values (I have created a data validation list where only 1 or 0 is permitted). Another column, C, is based on the value in column B, i.e. if a cell in column B has a 1 in it, you're supposed to choose between 1 and -1 in column C. If the cell in column B has a 0 in it you must choose 0 in column C.

What I'd like to do now is to conditionally format the data validation list for all the cells in column C, so as to only display the options 1 and -1 in col C if 1 is entered in col B and only display option 0 in col C if a 0 is entered in col B.
How do I do this?

Hi,

Check out this link. This site is another great resource.

http://www.contextures.com/xlDataVal02.html

HTH
Steve

I'm sorry, but I don't see how that will help me. I have no text in my validation lists, only numeric values. Maybe it's me being stupid, but I can't get that tutorial to apply to my situation.

Hi,

In column C use the Data Validation option list and enter this,

=IF(A1=0,Zeros,Ones)

Where "Zeros" is a named range with just a 0 and Ones is a named range with -1 and 1.

HTH
Steve