Hi,
I hope this doesn't come across too confusing, as i know what i am trying to do but i don't know how to describe it properly.
I have a spreadsheet where there are 5 questions which i want to assign a value to the response to the question then get a tally to add it up at the end and apply a color to the number based on where it finishes.
Some of the questions have a yes/no answer, some of the questions have up to 5 answers. I want to add a value to those answers, for example a yes will have a value of 20 and a no a value of 0.
Here is an example of what i am trying to do.
Capture.JPG
Any help would be appreciated
Thank you.
Bookmarks