Forum Discussion

Chonski950's avatar
Chonski950
Copper Contributor
Mar 02, 2023
Solved

Conditional formating rows in sharepoint list based on values

Hi, I have a sharepoint list that is fed by a Powerapps form. I'd like to color the rows according to the following parameters but I have no idea where to start from : Condition 1 : if column 1 = ...
  • SvenSieverding's avatar
    Mar 02, 2023

    HI Chonski950 

     

    this is conditional row formatting.
    Go to your list in SharePoint and select "All Items"->Format current view

    select "Conditional Formatting"



    Now set the set the formatting for  "Show all values as" to green as a default.

    Now click "Add a Rule"

    and select the rule and Formattig you want to apply


    You can add multiple rules like

    if column 1 is equal to "00000000" then red

    if column 9 is equal to "" (nothing, just leave empty) then orange
    if column 10 is equal to "" (nothing, just leave empty) then orange
    if column 11 is equal to "" (nothing, just leave empty) then orange
    if column 13 is equal to "" (nothing, just leave empty) then orange
    (You already set the column to be displayed in green in the default settings above)


    Save these rules




    Best Regards,
    Sven

Resources