Friday, 21 May 2010

Color Coded SharePoint Calendar

Once i had to give different color for the Calendar items. Below are the steps i followed

1. Created one Calculated Column with title 'ColorTitle'
2. Added the formula
="<div style='border: 1px solid #009933; padding: 3px; margin: 0px; background-color: #FFFFB0; color: #009933'>"&Title&"</div>"
3. Edited the default view as below
     a. Chose 'ColorTitle' for Month View Title
     b. Chose 'ColorTitle' for Week View Title


Saved the view. Thats all :)

Note: You can change the color based on a field value by slightly modifiying the formula.

1 comments:

sai said...

is ther way to stop duplicate the same timeing when a new item is created.

For example if i blocked the location A at 9:00 to 9:30 Am. if another user trys to block the same Loaction A at 9:15 to 9:45 is there a way to display the location A is Booked already