Checking/making-positive one cell unchecks other cells in range

C

CL

I have a worksheet with three ranges of 4, 3, and 2 cells on each row.
In each range, making one cell "true" means that the other cells are
false.

The first thing that comes to mind would be putting checkbox controls
in each cell; however, there will be 10,000, and possibly more, rows
like this making such a solution prohibitive.

Thanks in advance.
 
Top