Colour transparency issue in formatted columns since in the SP Update

%3CLINGO-SUB%20id%3D%22lingo-sub-1423768%22%20slang%3D%22en-US%22%3EColour%20transparency%20issue%20in%20formatted%20columns%20since%20in%20the%20SP%20Update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423768%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20of%20a%20week%20ago...%20for%20a%20random%20reason%2C%20all%20the%20colours%20apart%20from%20Blue%20and%20Grey%20are%20set%26nbsp%3B%20to%20very%20high%20transparency%20but%20this%20only%20applies%20for%20formatting%20a%20column%20in%20a%20list...%20as%20you%20can%20see%20from%20the%20second%20picture%2C%20the%20colours%20are%20'normal'%20for%20text%2C%20can%20anyone%20please%20offer%20any%20advise%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SPproblems.JPG%22%20style%3D%22width%3A%20293px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195032iB9AAB64ACCEEF993%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22SPproblems.JPG%22%20alt%3D%22SPproblems.JPG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SP2.JPG%22%20style%3D%22width%3A%20452px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195033i3297FF9D76A46A4C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22SP2.JPG%22%20alt%3D%22SP2.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1423768%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423975%22%20slang%3D%22en-US%22%3ERe%3A%20Colour%20transparency%20issue%20in%20formatted%20columns%20since%20in%20the%20SP%20Update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423975%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F520985%22%20target%3D%22_blank%22%3E%40Richard_W_01%3C%2FA%3E%26nbsp%3BYou%20can%20always%20select%20your%20own%20color%20codes%20to%20and%20use%20them%20instead%20of%20their%20as%20shown%20below%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_0-1590677085053.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195063i7F0ED35E5C7CC529%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_0-1590677085053.png%22%20alt%3D%22Vikram_Samal_0-1590677085053.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGo%20to%20the%20advanced%20mode%20of%20the%20format%20column%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20add%20the%20json%20format%20logic%20and%20use%20your%20own%20color%20codes%20from%20here%3A%3CA%20href%3D%22https%3A%2F%2Fhtmlcolorcodes.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fhtmlcolorcodes.com%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20below%20example%20we%20have%20shown%20how%20to%20color%20code%20the%20columns%20on%20the%20basis%20of%20value%20similarly%20you%20can%20use%20your%20logic.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%7B%0A%20%20%22%24schema%22%3A%20%22https%3A%2F%2Fdeveloper.microsoft.com%2Fjson-schemas%2Fsp%2Fv2%2Fcolumn-formatting.schema.json%22%2C%0A%20%20%22elmType%22%3A%20%22div%22%2C%0A%20%20%22txtContent%22%3A%20%22%40currentField%22%2C%0A%20%20%22style%22%3A%20%7B%0A%20%20%20%20%22background-color%22%3A%20%22%3Dif(%40currentField%26lt%3B50%2C%20'%23F5B7B1'%2C%20'%2382E0AA')%22%0A%20%20%7D%0A%7D%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EMark%20the%20response%20appropriately%20if%20it%20help%20you%20finding%20the%20solution.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EVik%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1424225%22%20slang%3D%22en-US%22%3ERe%3A%20Colour%20transparency%20issue%20in%20formatted%20columns%20since%20in%20the%20SP%20Update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1424225%22%20slang%3D%22en-US%22%3E%3CP%3Ethank%20you%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394813%22%20target%3D%22_blank%22%3E%40Vikram_Samal%3C%2FA%3E%26nbsp%3B%20worked%20perfectly%20%3A)%3C%2Fimg%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1424327%22%20slang%3D%22en-US%22%3ERe%3A%20Colour%20transparency%20issue%20in%20formatted%20columns%20since%20in%20the%20SP%20Update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1424327%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F520985%22%20target%3D%22_blank%22%3E%40Richard_W_01%3C%2FA%3E%26nbsp%3BThanks%20Richard%20for%20the%20confirmation.%20If%20you%20can%20mark%20the%20response%20as%20best%20solution%20it%20will%20help%20others%20to%20get%20to%20the%20solution%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EVik%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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?  

 

SPproblems.JPGSP2.JPG

3 Replies
Highlighted

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

Vikram_Samal_0-1590677085053.png

 

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

Highlighted
Highlighted

@Richard_W_01 Thanks Richard for the confirmation. If you can mark the response as best solution it will help others to get to the solution as well.

 

Thanks

Vik