excel validation, enter particular score in only one cell of a ran
 

Hello to you,

I have to create some validation in a particular worksheet: here comes the
description of what I am looking for help on:
The worksheet should allow the user to only enter data in only one of four
possible cells, and in that particular cell, they can only be a score of a
particular type, ie: 0, 0.5, 1, 1.5, 2, 2.5, 3, 3.5, 4.

I am able to validate the cells to only input those scores mentioned (via
list validation), but I have having trouble restricting usage to only one
cell of the four.

I really want to avoid using macros if possible, but if worse comes to
worst, I am happy to take your advice on how to use them.

Much obligued

Setup data validation in those cells. See
http://www.contextures.com/xlDataVal01.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"H.A. from London" <H.A. from wrote in
message ...
Hello to you,

I have to create some validation in a particular worksheet: here comes the
description of what I am looking for help on:
The worksheet should allow the user to only enter data in only one of four
possible cells, and in that particular cell, they can only be a score of a
particular type, ie: 0, 0.5, 1, 1.5, 2, 2.5, 3, 3.5, 4.

I am able to validate the cells to only input those scores mentioned (via
list validation), but I have having trouble restricting usage to only one
cell of the four.

I really want to avoid using macros if possible, but if worse comes to
worst, I am happy to take your advice on how to use them.

Much obligued