Conditional Formatting a Date Column

Question

I am completely all new to this.

I have a simple SharePoint list recording training.

What coding would I need to write in, to achieve the following:

• blank fields - color red
• anything else with a date in goes green.

Answer 1

For your requirements, you have to use the Column formatting in SharePoint. Follow steps given here in official documentation to open column formatting settings & add below JSON code.

You can use simple JSON like below to format your date columns:

{
    "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
    "elmType": "div",
    "txtContent": "@currentField",
    "attributes": {
        "class": "=if(Number(@currentField) == 0, 'sp-field-severity--blocked', 'sp-field-severity--good')"
    }
}

Output:

See other ways to check if date column is empty at: SharePoint JSON formatting: Check if date & time column is blank/empty

---

Official documentation: Use column formatting to customize SharePoint

Answer 2

You can use column formatting to meet your needs in SharePoint Online.

Please following steps:

1.Go to the list as a site admin

2.Select the "Date and time" column >> Column settings >> Format this column

3.On the Format Column windows, click on "Advanced mode" link

4.Please use the below JSON code

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "attributes": {
    "class": "=if(Number(@currentField) == 0, 'sp-field-severity--blocked','sp-field-severity--good')"
  }
}

5.Click "Save"