JSON Conditional formatting for Column

Question

I'm a bit of a noob about JSON and I want to use it to my benefit. What I want to do based on the attachment is the following:

Latin Qual Required? column is set to Choice setting and Latin Qual Date column is set to Short Date setting

• If Latin Qual Required? column has "Yes" and the Latin Qual Date is empty, change cell to background color with a specific hex code or the "error" class with Icon.
• If Latin Qual Required? column has "Yes" and the Latin Qual Date is entered, change cell to background color with a specific hex code "success" class with Icon.
• If Latin Qual Required? column has "Yes" and the Latin Qual Date is empty, change cell to red or the "error" class with Icon.
• If Latin Qual Required? column has "No" a change cell to background color with a specific hex code

Answer 1

The below JSON helps you to get the required output. Add the below snippet to the in Latin Qual Required? field column format. I assumed the internal name for Latin Qual Required? is Title and internal name for Latin Qual date is StartDate

    {
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "attributes": {
"class": "=if(Number([$StartDate]) == 0, 'sp-field-severity--blocked', if(@currentField == 'Yes','sp-field-severity--good','sp-field-severity--blocked')) + ' ms-fontColor-neutralSecondary'"

  },
  "children": [
    {
      "elmType": "span",
      "style": {
        "display": "inline-block",
        "padding": "0 4px"
      },
      "attributes": {
        "iconName": "=if(Number([$StartDate]) == 0, 'Warning', if(@currentField == 'Yes','CheckMark','Warning'))"
      }
    },
    {
      "elmType": "span",
      "txtContent": "@currentField"
    }
  ]
}

The output looks likes below,

g

I hope this helps to solve your query.