...
You can copy and paste the ids from that list into your expression.
...
How to set background colors for different scores (since Version 2.9.2)
(Font colors coming soon)
When configuring a Calculated Field you can set formatting rules to highlight certain ranges of scores with a background-color.
Click on the Add formatting rule button.
...
This will create a new formatting rule that can then be configured.
...
Now you can set a number as start for this rule, another number as end and a color via the colorpicker.
...
and colors for the background and the font of the score via the colorpickers. (Font color picker coming soon.)
...
You can add as many formatting rules as you like.
...
Note that the rules will be checked from top to bottom and the first that fits will be applied. So in our example -10 will be red. 20 will be yellow. 21 will be green. 10000 will be greenblue.
Values that are not covert by the rules will be shown with a white background and in a black font.
...