Column conditions
 

I have a series of columns, say A, B, C, D, E, F. Each of the cells in these
columns have drop down menus with "0" or "1" as the possible responses. For
each individual row is it possible to have only one answer of "1" and
autofill the other 5 columns with "0"? For example if "1" is selected in row
5 column A, row 5 columns B,C,D,E,F return "0" or if "1" is selected in row 6
Column C, row 6 columns A,B,D,E,F return "0" etc.

Hope this makes sense.

Cheers!

Column conditions
 

How about an alternative.

Put a formula in column G:

=if(sum(a1:F1)=0,"","Error: Only one choice can be 1!")

Then format it with a nice bold red font.

Zoltan wrote:

I have a series of columns, say A, B, C, D, E, F. Each of the cells in these
columns have drop down menus with "0" or "1" as the possible responses. For
each individual row is it possible to have only one answer of "1" and
autofill the other 5 columns with "0"? For example if "1" is selected in row
5 column A, row 5 columns B,C,D,E,F return "0" or if "1" is selected in row 6
Column C, row 6 columns A,B,D,E,F return "0" etc.

Hope this makes sense.

Cheers!

--

Dave Peterson

Column conditions
 

ps. You may want to consider using Optionbuttons (from the Forms toolbar) and
grouping them nicely. Then the problem of selecting more than one will go away.

If you want to try, visit Debra Dalgleish's site:
http://contextures.com/xlForm01.html



Zoltan wrote:

I have a series of columns, say A, B, C, D, E, F. Each of the cells in these
columns have drop down menus with "0" or "1" as the possible responses. For
each individual row is it possible to have only one answer of "1" and
autofill the other 5 columns with "0"? For example if "1" is selected in row
5 column A, row 5 columns B,C,D,E,F return "0" or if "1" is selected in row 6
Column C, row 6 columns A,B,D,E,F return "0" etc.

Hope this makes sense.

Cheers!

--

Dave Peterson