Path to SharePoint

The HTML Calculated Column

Indicator Values - Formula Generator

Ref. Column (number)
Target Values From smallest to greatest (max. 7)	20 40 60 80 100
Displayed Column:
Apply color to:

Pick a color for each choice:

Value <

<= Value <

The formula generator helps you build color coded lists or calendars in SharePoint.

See this article for detailed explanations (and this other one for calendar views).

To build your color coded field:

1/ Fill out the form

2/ Click on "Generate formula"

3/ Follow the instructions to include the formula in SharePoint:
- for lists, see this article.
- for calendars, see here.