SharePoint list calendar view formatting

I will discuss color coding in the SharePoint list calendar view in this SharePoint Online tutorial. Then I will show you how to create a calendar view in the SharePoint Online list and also how to do SharePoint list calendar view formatting.

Scenario:

According to my business requirement, I have to create a SharePoint calendar view and color code the SharePoint list so that users easily find out the events or tasks.

Color coding in SharePoint list calendar view

Color coding in the SharePoint Online list calendar view helps users distinguish between tasks or events based on different criteria. It also helps the users to look at, whether a block is for meetings, outings, holidays, lunch, etc.

For Example, we have done Color code in the SharePoint Online List Calendar View, as shown below.

sharepoint list calendar view formatting

Create a SharePoint list calendar view color coding

Let’s see how to create a SharePoint Online list calendar view. To achieve it, follow the below steps.

  • Open a SharePoint Online List, click All Items, then click ‘Create new view‘.
sharepoint list calendar view color coding
SharePoint Online List Calendar View
  • In this Create view window, we need to provide the following details:
    • View name = Provide a new view name like Calendar.
    • Show as = We have selected Calendar.
    • Default layout = Month
    • Start date on calendar = Start date
    • End date on calendar = End date
    • Visibility = Select to Make this a public view.
  • Click on the More option
    • Title of items on the calendar = Expands it and select the column as per your need.
  • Click on Create button.
sharepoint online list calendar view color coding
  • Again go back to SharePoint Online List (MB Calendar) home page -> Expand the All Items -> Select the view that we have created (Calendar).
sharepoint modern list calendar view color coding
  • The screenshot below represents the color coding Calendar view with the SharePoint title values.
sharepoint calendar color code

This is how we can create a SharePoint Online list calendar view.

SharePoint List Calendar View Formatting

Here, we will see how to format the current view of the calendar in the SharePoint List.

  • Dropdown the Calendar and click on the Format current view. Then in the Format view tab, click on Manage rules under Conditional formatting.
sharepoint list calendar view formatting
sharepoint list calendar view conditional formatting
  • Under the Conditional formatting window, click on …(ellipsis) -> Select Edit rule.
SharePoint Online List Color Code in Calendar View
  • In this Edit Rule window, we have to provide value for,
    • Choose a column = Provide a column to compare
    • Choose a comparison = Select the operator
    • Choose or Type a value = Provide a value to be compared
    • Show list item as (Color) = Choose a color to show a list item
  • Rule 1:

In this case, we have taken column (Start date), which is compared (is before) the specific date (4/9/2023). If it matches the situation, the item on the list will be shown in the selected color (Red).

  1. Chosen Column = Start Date
  2. Choose a comparison = is before
  3. Chosen Type value = 4/9/2023
  4. Show list item as (Color) = Red
SharePoint List Calendar View Formatting
  • Rule 2:

In this case, we have taken column (Start Date), which is compared (is between) the date (4/10/2023) to (4/14/2023). If it matches the situation, the item on the list will be shown in the selected color (Green).

  1. Chosen Column = Start Date
  2. Comparison condition = is between
  3. Chosen Type value = 4/10/2023 to 4/14/2023
  4. Show list item as (Color) = Green
SharePoint Online Calendar Color Coding
  • Rule 3:

In this case, we have taken column (End date), which is compared (is between) the date (4/20/2023) to (4/26/2023). If it matches the situation, the item on the list will be shown in the selected color (Yellow).

  1. Chosen Column = End Date
  2. Comparison condition = is between
  3. Chosen Type value = 4/20/2023 to 4/26/2023
  4. Show list item as (Color) = Yellow
sharepoint list calendar view formatting
  • Rule 4:

In this case, we have taken column (End date), which compared (is on or after) the specific date (5/1/2023). If it matches the situation, the item on the list will be shown in the selected color (Blue).

  1. Chosen Column = End Date
  2. Comparison condition = is on or after
  3. Chosen Type value = 5/1/2023
  4. Show list item as (Color) = Blue
SharePoint Online Calendar View Color Coding
  • Now, we can see after formatting the view how the SharePoint Online List Calendar view color coding looks as shown below.
Color Coding SharePoint Online List Calendar View

This is how to do Color Coding in SharePoint Online List Calendar View using the format current view.

Conclusion

Here, we have learned about the SharePoint Online List Calendar View Color Coding from this tutorial, along with several other topics that are discussed, which are given below.

You may also like: