Conditional Formatting in Microsoft Lists

Question

Hello,

I am trying to have two date columns within Microsoft Lists highlight based on the following:

Column 1 (Last DOT inspection date). Example date: 7/1/2022 would highlight red

• if date is < 365 days RED
• if date is < 335 days YELLOW
• if date is < 305 days GREEN

Column 2 (Last BIT inspection date). Example date: 5/1/2022 would highlight red.

• if date is < 90 days RED
• if date is < 60 days YELLOW
• if date is < 30 days GREEN

Thinking I'm going to have to use JSON but I'm not very familiar with that.

Thank you!

Answer 1

Dear Gaby Gorgol,

Thanks for posting in Microsoft community.

We'd love to help, considering we mainly focus on general and build-in queries in SharePoint Online, we may have limited resource about JSON code.

At the same time, considering we have a dedicated channel SharePoint Development - Microsoft Q&A, for you to be assisted properly, we sincerely recommend you go to that community and post a new thread, members and engineers over there are proficient in the knowledge of SharePoint customization queries. They will focus on the specific situation on your side and share specific suggestions. We are sure that our experts from that team can address your query effectively and accurately.

Thanks for your understanding and cooperation! Hope you keep safe and healthy always.

Sincerely,

Sean | Microsoft Community Moderator