Hi,
For your assistance, please. I'm having another problem on my other Sharepoint list that I'm creating.
I'd need to have a particular cell to be highlighted as red if it is already beyond the current date (weekends and holidays should not be included). Please refer to the screenshot of Excel example:
Let's assume that today is May 6, 2024:
There will be no red highlight as it is currently within the date. This includes the weekends of Saturday and Sunday:
There will be red highlight as it is already beyond the date of May 6, 2024. It is already highlighted as May 6 is already the 3rd date and is beyond the date:
There will be no red highlight even if closed date is empty as it is still within the due date. May 6 is only the second day:
To summarize it, closed date and review date are both necessary cells as they will be interacting with each other. I've already managed to do it in Excel Conditional Formatting but I'm having a hard time to do it in JSON conditional formatting via Sharepoint.
Your help will be much appreciated. Thank you!