How to display colour coded sections on sharepoint calendar

Question

Hi,

I'm creating a calendar that I can share with colleagues to show which staff members have annual leave each date. I have created a column that signifies what role the staff member does (for example, colleague A might be senior and therefore only one senior member of staff can be off this day).

The colours display when I am in the all item view, but not the calendar/month view. Any way to change this please?

Answer 1

Hi @loumrsn93

Regarding your issue, the colors you've set up on your choice column live at the column level, which means they show in the All-Items view but don't automatically follow through to the Calendar view. The Calendar view needs its own formatting applied directly to it.

I've tried to recreate this issue on my end; here are a few steps you can try:

1. Get your column to appear in the Rules

• Open your Calendar view.
• From the view dropdown at the top-right of the command bar, select Edit current view.
• 
• In the panel that appears, scroll to the bottom setting labelled Title of items on calendar.
• Temporarily switch this from Title to your choice column (for me here it's Testing Calendar view).
• 
• Click Save.

2. Set up your Colors

• Open the view dropdown again and select Format current view.
• 
• Choose Conditional formatting > click Manage rules.
• 
• Click + Add rule.
• 
• Under the If condition, select Choose a column and your choice column should now appear in the list.
• Define each rule (e.g., If [column] is equal to Band 6).
• 
• Click the color palette icon next to Sample text, pick your background color, and click Save.
• Repeat for each value.

3. Switch your Titles back

• Open the view dropdown one final time and select Edit current view.
• Change Title of items on calendar back to Title.
• 
• Click Save.
• Here is what it looks like from my testing
• 

For more details, please refer to: Format a column to change how it looks

Note:

• If the colors don't show straight after saving, switch to the All Items view and then back to the Calendar view they'll appear.
• Calendar conditional formatting supports one color per item (so you can't show two colors if two different bands land on the same tile)

Hopefully it will help resolve your issue, if it doesn’t work as expected or you run into any issues, feel free to get back to me anytime. I’d be happy to take a closer look and work through it together with you if needed.

Thank you for your patience and cooperation.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.