Color Code
From LongJump Support Wiki
This conditional color code function highlights rows based on the user-defined conditions in Views and Reports. Any number of conditions can be added for a variety of colorized views into your data.
Records that match the selected criteria will have that color applied. You can select multiple criteria to create multiple color codes in a report. Color coding applies to Views and 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