Share via

Conditional formatting based on date and status

Anonymous
2024-02-08T14:21:22+00:00

I have a work tracker list that provides a Due Date column and a Status column. When searching for a solution to my issue, I could only find articles about conditional formatting based solely on a date. But I need to find a way to mark a row (or just a cell in a row) red, if the Status is NOT "Completed" and the Due Date has passed. I can do this in Excel with a formula, but I can't figure out how to do this in Lists. Has anyone been able to do this?

Microsoft 365 and Office | Install, redeem, activate | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-02-08T21:21:09+00:00

    Dear Elizabeth Robson,

    Thank you for reaching out to the Microsoft community. We are delighted to offer our assistance.

    After carefully reviewing your description, we think JSON code may help you with your requirements. These references may help you with your requirements: list - conditional formatting based on status of the field and date sharepoint/Use column formatting to customize SharePoint | Microsoft Learn.

    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 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

    Was this answer helpful?

    0 comments