Applying "transparent" conditional formatting in the UX
When we apply conditional formatting to a grid in the UX, there is no option to set a transparent color. However, with some creative use of specific color codes, we can simulate the transparent effect.
I will focus on two specific cases below: editable cells and read-only cells. Both of these cases follow the same approach of picking the correct color for your default cells by leveraging the UX ability to manually enter a hex code for your color.
Transparent conditional formatting for editable cells
Setting a transparent conditional formatting background for editable cells is fairly intuitive. Editable cells in Anaplan will always have a white background, so you can pick the preset option for white in your color picker. Alternatively, you can manually enter a custom hex code of #FFFFFF.
Configuration:
Result:
Transparent conditional formatting for read-only cells
Setting a transparent conditional format background for read-only cells is actually equally as simple! You just need to know the hex color code for read-only cells in Anaplan, which is #F7F9FD.
Configuration:
Result:
Feel free to post a comment below with any questions, comments, or suggestions!
Comments
-
@ryan_kohn - what a workaround - I love it
0 -
This works well until you use the striped function under row style, which our customers like to view a row of data. Can Anaplan not make the transparent option for conditional formatting?
0 -
if you add a condition equal to NaN, no color will be applied when color coding will be equal to NaN.
How I do :- Create a line item in seting module called NaN
- NaN is setup as a number: formula - value(blank)
- I use this line item in the conditional formatting line item
2 -
Thanks @AntoineHM That works perfectly.
0