Making a rating from 1-12 with no overlap for a quastionaire

Hi guys!

I am making a questionnaire in Excel and i was wondering if it is possible to make someone rate 12 different attributes from 1 to 12 without there being any overlap in number (so that non attribute gets the same number and that no one gives a rating of 13). I already figured out the combobox function but i can't figure this one out

Help is much appreciated!!

I am doing it in a sheet in excel 2013

Thanks a lot! Maybe a stupid question, but how do i transform this in the macro to make it work? it keeps on giving errors if i try

Thanks a lot Nathan!

Hello
Why not just use data validation for cells? You can
1. add validation rule to a range (a list of numbers from 1 to 12), so there will be no any other values than from this list
or
2. add validation rule to a range of such cells with formula (

Formula:

Please Login or Register  to view this content.

)

Or, you can use 1st trick and conditional formatting with modified formula from 2nd:

Formula:

Please Login or Register  to view this content.

See attachment

I must say that i really start to love you guys on this forum! Thanks Hohlick :D