I would like to visually show when the locations are different.

So I have 2 rooms that we use Room 1 and Room 2 (location is a free text value but we would use the same text).

I would like these in a calendar view to have different colors, to distinguish between the different session.

Is this possible? or is JSON only for list view?


1 Answer 1


If you are using SharePoint Online Modern list calendar view, you can use SharePoint JSON conditional formatting rules to color code the events based on columns (like Location) in the list.


List Data:

enter image description here

Conditional formatting rules & calendar color coding:

enter image description here

Steps to apply conditional formatting:

  1. Go to your SharePoint modern calendar view

  2. Click on Switch view options drop down and select Format current view:

    enter image description here

  3. Select "Month" in drop down and click Manage rules:

    enter image description here

  4. Add rules as per your requirements and save the changes:

    enter image description here

Note: After creating a calendar view and before applying conditional formatting, you may need to show/include location column in your calendar view settings.

Refer this threads for more information and steps for same: Conditional Formatting in Calendar View is not showing a Column

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.