Formula syntax error when color coding a sharepoint calendar

Microsoft Excel 2010 - complete product...
October 4, 2012 at 11:35:44
Specs: Windows 7
I am trying to set up a color cordinated calendar on SharePoint 2010. I have a category column, a color column and a display column. I am using a tutorial from the following website:

However when I copy in my formula I get the following error and I am not sure why:

The formula contains a syntax error or is not supported.
Learn more about the syntax for formulas.

Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: ad7c2abc-7b01-43da-95cc-9eaa0a4e561a

Date and Time: 10/4/2012 2:19:33 PM

The formulas I am I am using are:

Color Column:

=IF([Status]="","LightSkyBlue",IF([Status]="Birthday","Red",IF([Status]="Education","Orange",IF([Status]="Stat Holiday","Gold",IF([Status]="Team Event","Green",IF([Status]="Vacation","Blue",IF([Status]="Working Off-site","Purple",IF([Status]="Other","DeepPink",""))))))))

Detail Column:

="<span style='position:relative;display:inline-block;width:100%;'><span style='width:100%;display:inline-block;text-align:center;border:1px solid "&[Color]&";position:absolute;color:"&[Color]&";'> "&[Title]&"</span><span style='display:inline-block;width: 100%;background-color:"&[Color]&";text-align:center;border:1px solid;z-index:-1;filter:alpha(opacity=20);opacity:0.2;'>"&[Title]&"</span></span>"

Any pointers would be awesome!

See More: Formula syntax error when color coding a sharepoint calendar

October 4, 2012 at 11:44:58
Nevermind, I figured this out.

Report •

November 29, 2012 at 23:24:18
May I ask how you solved your problem?
I have the same isuue, trying to color code a column for a list!

Thank You

Report •
Related Solutions

Ask Question