Skip Ribbon Commands
Skip to main content
 

 Select Your Options

 

Choice Column

 

Choices (max. 7)

Displayed Column

Apply Color to



Draw Border

Color format

Text alignment

Cursor style

Separate Color Column

Column name: 

Language

 
   Choice 0: (No choice selected)
   Choice 1:
   Choice 2:
   Choice 3:
   Choice 4:
   Choice 5:
   Choice 6:
   Choice 7:

The formula below is updated dynamically based on your selection.

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

 

 Instructions

 

 

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

 

 Downloads

 
  
  
  
  
TextToHTMLlite-v2.1.1.dwp
  
Light version, for both SharePoint 2003 and 2007 - Applies the rendering to displayed items only.No presence informationChristophe
TextToHTMLlite-v2.1.1.txt
  
Light version, for both SharePoint 2003 and 2007 - Applies the rendering to displayed items only.No presence informationChristophe
TextToHTML-v2.1.1.dwp
  
Full version (SP 2007) - Applies the rendering to displayed and hidden items (grouped views, preview pane, etc.). Warning: the script encapsulates some of the SharePoint OOTB code.No presence informationChristophe
TextToHTML-v2.1.1.txt
  
Full version (SP 2007) - Applies the rendering to displayed and hidden items (grouped views, preview pane, etc.). Warning: the script encapsulates some of the SharePoint OOTB code.No presence informationChristophe
Copyright © 2011 User Managed Solutions, LLC