Column conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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