The HTML Calculated Column

Update [April 6, 2010]

A new version of the formula generator is now available here:

Pick a color for each choice:

Choice 0 (no selection)

Choice 1:  

Choice 2:  

Choice 3:  

Choice 4:  

Choice 5:  

Choice 6:  

Choice 7:  

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

To build your color coded field:

1/ Fill out the form.

2/ Click on "Generate formula" and copy the formula.

3/ Create a calculated column in your list, where you'll paste the formula.

4/ Get the script available under the download tab and add it to the page, under your list.

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

Contact: Christophe@PathToSharePoint.com

To download a file, right-click on the file name and select "Save Target As".