Color Code
From AgileApps Support Wiki
Revision as of 23:39, 12 June 2014 by imported>Aeric
This conditional color code function highlights rows based on the user-defined conditions in Reports. Any number of conditions can be added to color your data. Records that match specified criteria are displayed with the selected background color.
- Considerations
-
- Color coding applies to Tabular Reports only, not Matrix or Chart Reports.
How it works
- Select a data field
- Define a true/false condition
- Choose a color from the color palette
Up to 10 conditions can be specified.
A typical condition might be "Status is equal to In Progress", or "Expected Revenue is greater than $1000".
When the condition is true, that row will be highlighted in the color you choose.
Exceptions
Some field types cannot be used for color coding, including:
- Lookups and Related to Lookups
- Dependent Multi-Fields
- Multi-Checkbox
- Multi-Picklists
- Rich Text Areas
- File and Image fields
- Multi-Select Lookups