Hi, I tried grouping didn't work. I have to have a choice of two individuals
who could be responsible. so each would have a check box against their
column and the user would select one accordingly. When I have the two
checkboxes it allows them to select both which i don't want to be the case?

"Bob Phillips" wrote:

Radio buttons need to be grouped to be separated.

As a checkbox has two states, checked or not, why not just use one per row
and react according to its status?

--
HTH

Bob Phillips

"shezzer_1972" wrote in message
...
Problem: I have two columns which each has a check box. I want only one
check post to be selected as the two are related i.e.

which contractor will you use contractor 1
contractor 2
who has best rates contractor 1
contractor 2
etc
etc

when I use radio buttons for some strange reason it only ever allows me to
check on radio button on the spreadsheet (could be stupid user syndrome!).
Can anyone help with the best way to work this.

thanks