...
We can set cells within our report results to be coloured based on certain criteria. For example, records open longer than 5, 10, 20 days; Risk Rated High or Extreme and so on.
the format is x to y:color
and use ; as the rule separator
Here we have set a rule on the Summary table, first selecting the Settings toggle next to the ‘Total Incidents’ field. Then we have set the cell highlight rule of:
5 to 6:Blue;7 to 10:Red
...
Tip: Any official HTML colour can be used in your highlight rules. Here is a guide I refer to:
https://www.cknow.com/cms/articles/what-are-the-official-html-color-names-and-hex-codes-3.html
...