Hey, I have a 10 point scale (1,2,3,4,5,6,7,8,9,10) and each number has a set colour attacthed to it. I then have names on the left and for example, uniform and behaviour on the top row, so each week i update each persons scale based on the 10 point system. However I need the total value of each topic per person. Like (green, green, yellow, red, orange) should equal 10+10+5+1+3=28/50. I am wanting to make it so that i can just change the number within the cell and have the colour change accordingly to the value (and also hide the text (number)) in the mean time.

​Hey, I have a 10 point scale (1,2,3,4,5,6,7,8,9,10) and each number has a set colour attacthed to it. I then have names on the left and for example, uniform and behaviour on the top row, so each week i update each persons scale based on the 10 point system. However I need the total value of each topic per person. Like (green, green, yellow, red, orange) should equal 10+10+5+1+3=28/50. I am wanting to make it so that i can just change the number within the cell and have the colour change accordingly to the value (and also hide the text (number)) in the mean time.  Read More

​