Share via

List formatting based on multiple conditions

Builder 21 Reputation points
2021-04-28T08:46:13.22+00:00

Hi
I have a list with four columns: Approval Status / PR Number / PO Number / Goods Receipted.
I require JSON for formatting the current view of a Sharepoint list. I am lost on multple and or kinda operators...if anyone can help that would be great.
If all are blank no formatting
If Approval Status Approved (and all other columns blank - at this stage they won't have info) row colour PINK
If Approval Status Rejected (and all other columns blank - at this stage they won't have info) row colour GREY
If Approval Status Approved and PR Number contains information (all others blank) row colour YELLOW
If Approval Status Approved and PR Number and PO Number contain information (goods receipted still blank) row colour GREEN
If Approval Status Approved and PR Number and PO Number contain information and Goods Receipted Yes row colour BLUE

Thanks if you have time to ponder.

Microsoft 365 and Office SharePoint For business Windows
Accepted answer
  1. CaseyYang-MSFT 10,461 Reputation points
    2021-04-29T10:10:54.263+00:00

    Hi @Builder

    Please click All items -> Format current view -> Conditional formatting -> Manage rules -> Add rule.
    92615-111.png

    1.When Approval Status is Approved, PR Number and PO Number contain information and Goods Receipted is Yes. You can set rule as the following picture shows.
    92550-222.png

    2.When Approval Status is Approved, PR Number and PO Number contain information (Goods Receipted is blank). You can set rule as the following picture shows.
    92530-333.png

    3.When Approval Status is Approved and PR Number contains information (all others are blank). You can set rule as the following picture shows.
    92631-444.png

    4.When Approval Status is Rejected (all other columns). You set manage rule as the following picture shows.
    92632-555.png

    5.When Approval Status is Approved (all other columns blank). You can set rule as the following picture shows.
    92633-666.png

    Note: Please manage rules as the following orders: Blue -> Green -> Yellow -> Grey -> Pink.
    92616-88.png

    6.My test result as the following picture shows.
    92534-777.png

    If an Answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.