Forum Discussion
Highlight rows with overlapping dates
I have a SharePoint Modern list where I want to highlight any rows where the rows' Start Date and End Date overlap in time. For example, Row 1 has a Start Date of 8/22/23 and an End Date of 8/25/23. Row 2 has a Start Date of 8/23/23 and an End Date of 8/26/23. Row 5 has a Start Date of 8/24/23 and an End Date of 8/27/23. I want the rows that overlap to be highlighted in the same color indicating that these two events are going to overlap in time.
You can follow this article to create a modern calendar view: Create a modern Calendar view in SharePoint Online/Microsoft Lists
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
3 Replies
You can follow this article to create a modern calendar view: Create a modern Calendar view in SharePoint Online/Microsoft Lists
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Hi JenniferPigeon ,
as ganeshsanap said, there is no out of the box solution to do this in a list view.
But you could try to create a calendar view. You kind of get that effect there
Best Regards,
SvenJenniferPigeon Unfortunately, there is no SharePoint online modern experience out of the box options available for your requirements to highlight the rows with overlapping dates.
Both SharePoint calculated columns and JSON formatting cannot read the column values from another rows/items in the list.
You will have to use the custom solution for your requirements, probably SPFx field customizer to just highlight the date column cell or SPFx web part to develop complete new solution for list view (table structure) and color formatting OR use Power Apps to create canvas application and use it instead of default SharePoint list views.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
