I have a list with a column called Client Satisfaction which is a choice field with the following
1 2 3 4 5 6 7 8 9 10
I would like a calculated column to make any number between 1,2,3,4,5,6 red, 7 orange and 8,9,10 green
Here are some of the columns in the list, I would like the change the color of the Satisfaction number as stated above
What would the calculation be?