How do I do this??!

[marf]

I have a table where users need to assign a score to an item...

so for example:

Item 1
|criteria for the item to receive 5 points blah blah |_________|
|criteria for the item to receive 4 points blah blah |_________|
|criteria for the item to receive 3 points blah blah |_________|
|criteria for the item to receive 2 points blah blah |_________|
|criteria for the item to receive 1 points blah blah |_________|

Item 2
|criteria for the item to receive 5 points blah blah |_________|
|criteria for the item to receive 4 points blah blah |_________|
|criteria for the item to receive 3 points blah blah |_________|
|criteria for the item to receive 2 points blah blah |_________|
|criteria for the item to receive 1 points blah blah |_________|

..
..
..
Item 10


I need the user to enter only 1 value in the column for that item. so for
example if they enter that the item gets a score of 5. I want the other rows
for that item to be zero.

I need some sort of macro or conditional statement that does that. I also
would like to highlight the cell where they input the score upon entering the
number....

How can I do this.. please help!!

 

[Flick Olmsford]

Why not just have one line per item with two cells - one showing the # of
points and the other showing the value.

You could make the # of points a drop down list with the values 1-5.