Color Coding a SharePoint List
In order to differentiate various list items and highlight key items, there can be applied a method of SharePoint list color coding. Let’s see how it works in adding colored status dots to a SharePoint report list - we’ll perform that through designating a certain color to each status value. Using a Calculated SharePoint List Column Open or create a SharePoint list that you want to add color coded status to, and go to List > List settings and click the Add a new column option. In the column creation tab, type in the name - Status indicator and select the column type - Choice. In the Choice option box enter the status colors - green, yeallow, red, and press OK. Next, create another column to display the color-coded dots. Enter the field name - Status, and select the field type – Calculated. We need to enter the formula here: ="<DIV style='font-weight:bold; font-size:50px; margin-top: 30px; color:"&[Status Indicator]&";'>•</DIV>" ...