Alternate and Conditional Formatting in Sharepoint List

Question

Is it possible to have both alternate row formatting (eg. blue/white), as well as conditional formatting based on a column value? I can get either to do what I want, but struggling to have both at the same time. I have a column called "Old", and if the value is "Yes" the entire row changes to red. Any help on the code would be appreciated!

Answer 1

Hi @James Jarman

Yes, as seen below I have alternating colors and conditional formatting:

How to have both:

1) Create the conditional formatting for the list:

a) Format this column

b) Go to Manage Rules > Add Rule > Make the rule and formatting you want.

2) Format the current view (for alternate coloring of rows)

a) Go to All Items > Format Current View

b) Add the JSON code:

{  
  "$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",  
  "additionalRowClass": "=if(@rowIndex%2==0,'ms-bgColor-themeLight','')"  
}  

Cited from https://techcommunity.microsoft.com/t5/sharepoint/sharepoint-list-alternating-column-formatting/m-p/2012389

c) Click Save

-------------------------------

If this is helpful please accept answer.

Answer 2

Thank you DillonJS, it worked!
Is it possible to expand this to the entire line to change color, or is it just the the column field that I'd be limited to? Appreciate all the help!