Calculated column colours

Question

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?

Thanks

Yes in the list view, I have updated my question with a screenshot, thanks — Matt Saunders, Commented Nov 12, 2014 at 19:59

Arsalan Adam Khatri · Accepted Answer · 2014-11-12 09:19:27Z

2

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

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

answered Nov 12, 2014 at 9:11

14.5k3 gold badges37 silver badges59 bronze badges

Thanks, the HTML calculated column link took me to about three sites and nothing for SP 2013, the other link for SP 2013 the addin is $900.
– Matt Saunders
Commented Nov 12, 2014 at 9:17
Answer is updated, please have a look.
– Arsalan Adam Khatri
Commented Nov 12, 2014 at 9:19
I am trying to use this link usermanagedsolutions.com/SharePoint-User-Toolkit/Pages/… but the column once added just says red, it does not display the number at all
– Matt Saunders
Commented Nov 12, 2014 at 9:42

Add a comment |

1 Answer 1