SharePoint Online list conditinal formatting

Question

Hi All,

Using SharePoint Modern list. Have a scenario like below. Here 'Completed' & 'Active' are list columns.

If Active !=1 then don't apply any color to entire row but for 'Completed' column values (Yes or No) apply formatting as choice pills CSS.

If Active ==1 then format entire row with yellow color & in this scenario, 'Completed' column should not have any color applied.

I can apply column formatting to 'Completed' column but not able to remove this formatting for the rows where Active=1. Want to remove column formatting if row formatting is applied.

Can anyone help?

Thanks,
Sanjay

Answer 1

@Sanjay Adsure ,

Per my test, we can not remove column formatting if row formatting is applied where Active ==1.

These two are independent and do not interfere with each other.

As a workaround, we can edit the default Choice pills in advanced mode:

Then change the column color to be the same as the row color:

Result for your reference:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.

---