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