Forum Discussion

Richard_W_01's avatar
Richard_W_01
Copper Contributor
May 28, 2020

Colour transparency issue in formatted columns since in the SP Update

As of a week ago... for a random reason, all the colours apart from Blue and Grey are set  to very high transparency but this only applies for formatting a column in a list... as you can see from the second picture, the colours are 'normal' for text, can anyone please offer any advise?  

 

microsoft lists
SharePoint Online
  • Vikram_Samal's avatar
    Vikram_Samal
    Steel Contributor
    May 28, 2020

    Richard_W_01 You can always select your own color codes to and use them instead of their as shown below:

     

    Go to the advanced mode of the format column

     

     

    Then add the json format logic and use your own color codes from here:https://htmlcolorcodes.com/

     

    In the below example we have shown how to color code the columns on the basis of value similarly you can use your logic.

     

     

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

     

     

     

    Mark the response appropriately if it help you finding the solution.

     

    Thanks,

    Vik

Resources