SharePoint List column conditional formatting

Question

New to this still on the learning road.

Situation. I have a SharePoint list that contains the following columns: Name, DOB, Location, Comments.

I need to use a conditional formatting rule that in the situation that the comments cell contains the text ".iso" the Name cell and the Location cell needs to change background into yellow. Is there a way to use a JSON script because with simple conditional formatting rules I cant create the condition if the column contains specific text.

Thanks in advance.

Answer 1

Add the following JSON to [Name] and [Location] columns

 
{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "background-color": "=if(indexOf(toLowerCase([$Comments]), '.iso')>-1, '#FFFF00', '')"
  }
}

See Column Formatting and Reference