Hi,
I have a little matrix 5R x 6C. All cells within the matrix have data validation in them to restrict the input to "1" or "0". It is OK to have mutiple selections of "1's" in the same row, except if the user happen to select a "1" for the sixth or last cell in the row. If that happens I would like the other five cells in that row to have a value of "0".
Something like

A B C D E F
1 1 0 0 1 1 0 ok
2 1 0 1 0 0 1 Not ok
3 0 0 0 0 0 1 ok
4
5