View Single Post
  #1   Report Post  
H.A. from London
 
Posts: n/a
Default 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