The SharePoint User's Toolkit

Choice Column
Choices (max. 7)	Not Started In Progress Completed Deferred Waiting on someone else
Displayed Column
Apply Color to	Text with semi-transparent background Text Background
Draw Border
Color format	Color Name (DarkBlue, Green, etc.)
Text alignment	Default Center
Cursor style	Auto Pointer (hand)
Separate Color Column	Column name:
Language	Dutch English French Italian

The formula below is updated dynamically based on your selection.

Alert! The formula has exceeded the 1024 length allowed in calculated columns. Consider storing the color in a separate column or reducing the number of choices.

Paste the following formula in the calculated column that will be displayed in the list or calendar:

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

To proceed:

1/ Fill out the form. Based on your choices, the formulas are automatically updated at the bottom of the form.

2/ Paste the formulas in calculated columns in your list.

3/ Get the script available in the Downloads page and add it to the page, under your list.

See this article for detailed explanations. And if you need more than 7 different colors, this other article will guide you.

Contact: Christophe@PathToSharePoint.com