Column conditions

Z

Zoltan

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

Dave Peterson

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