Forum Discussion

ElwinH's avatar
ElwinH
Copper Contributor
Dec 13, 2022

Changing a Cell colour

Dear all,

 

For a Sharepoint online "list", I would like to have a cell changed with colour (or added a colour) whenever the base value changes. Or at least, as soon as someone makes a change to that cell, I would like it automatically changed.

 

Is this possible?

 

Thank you in advance,

Eho

Lists
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Dec 13, 2022

    ElwinH You might be able to do it using JSON column formatting in SharePoint.

     

    Check below documentation: Use column formatting to customize SharePoint 

     

    For example: Show orange color if text column has any value else do not color the column: 

     

    {
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "background-color": "=if(@currentField == '', '', 'orange')"
  }
}

     

    Output: 

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources