How do I color code a row in a lists based on a 'Status" field. Essentially calculated field based on status column. I tried a feature called Spotlight which enter image description here


1 Answer 1



in June 2017, Microsoft disabled the use of JavaScript in a Calculated Column

That means given answers may not apply for newer SharePoint versions

For long explanation and work arounds see:
June 13th 2017 Microsoft blocked handling HTML markup in SharePoint calculated fields - how to get the same functionality back

Original answer:

The answer in the comments refers to the SP2007 style, where you needed extra JavaScript in a CEWP to convert a Calculated Column.

Since SP2010 executing HTML/JS can be done straight from the Calculated Column,
by setting the datatype to anything but Single Line of Text


for examples see

And I tagged all my answers of the past years with ICC:

answers with 'color':


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