Formula to autofill neighbouring cells when a value is added to another

I have created a questionnaire that has 3 columns where an answer can be provided (an answer is provided by entering a 1 in the appropriate column) however what I am trying to work out is whether I can apply a formula to the cells to stop the user from entering another 1 in another column causing duplicate answers per question. Any ideas?