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

enter image description here

What would the calculation be?


  • where do you want this color code. is it the list view? Nov 12, 2014 at 14:55
  • Yes in the list view, I have updated my question with a screenshot, thanks Nov 12, 2014 at 19:59

1 Answer 1


You need to use HTML calculate column for this, please have a look at:

HTML Calculated Column - Client Side Rendering

For SharePoint 2013, simplest way is to use Client-Side Rendering (JSLink property).. Please have a look at following samples:

Client-side rendering (JS Link) code samples


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.