Highlighting Cells in Reports and Editing Credential Alert Timeframe

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