Changing a Cell colour

Copper Contributor

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

1 Reply

@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

ganeshsanap_0-1670929838539.png


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.