How to restrict user to input only one of multiple cells
 

Hello, here's a problem I've been wrestling with. Is there any way to design
a worksheet that would only allow a user to enter a value in one of a group
of cells? For example, suppose A1, B1, and C1 were my group, corresponding to
outcomes like positive/neutral/negative. If the user makes an entry in B1,
say, the worksheet would disallow and/or delete anything in A1 or C1.

I know you can do this in VB, and I know you could avoid the problem
entirely by simply having one cell that was restricted (via Data Validation)
to the three outcomes above. But neither of these are options for me. Anyone
know how to do this as described?

James

How to restrict user to input only one of multiple cells
 

You are correct! Data Validation is the solution.

Data Validation Settings Custom Formula
=COUNTA($A$1:$C$1)<2

--
Gary''s Student - gsnu200802


"James" wrote:

Hello, here's a problem I've been wrestling with. Is there any way to design
a worksheet that would only allow a user to enter a value in one of a group
of cells? For example, suppose A1, B1, and C1 were my group, corresponding to
outcomes like positive/neutral/negative. If the user makes an entry in B1,
say, the worksheet would disallow and/or delete anything in A1 or C1.

I know you can do this in VB, and I know you could avoid the problem
entirely by simply having one cell that was restricted (via Data Validation)
to the three outcomes above. But neither of these are options for me. Anyone
know how to do this as described?

James