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 th...
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