Highlight data using a conditional style
For example, you want to automatically highlight in green the departments in your organization that meet their budget quotas and highlight in red the departments that go over budget. Creating conditional styles color-codes information in your reports so that you can find areas that need attention.
You can apply multiple conditional styles to objects. For example, you can apply one style in specific cells and another style for the overall report. If multiple styles set the same property, such as font color, the last style in the list is applied.
You can apply conditional styles based on any data item in your report.
You can create the following types of conditional styles.
Type | Description |
---|---|
Numeric Range |
Highlights straight numerical data, such as revenues and losses. |
Date/Time Range |
Highlights data from specific dates and times. |
Date Range |
Highlights data from specific dates. |
Time Range |
Highlights data from specific times. |
Interval |
Highlights data falling between set intervals. |
String |
Highlights specific alphanumeric items in a report. For example, you can highlight all instances of a specific word or phrase, such as Equipment. String criteria are case-sensitive. If multiple string conditions are met, only the first conditional style is applied. |
Advanced |
Creates conditional styles that use calculations or expressions. If multiple advanced conditions are met, only the first conditional style is applied. |
You can also apply a conditional color palette to a chart.
You can perform a search to find objects in your report that use conditional styles. You can also view all the conditional styles used in your report to delete or modify them.
You can also use variables to highlight data. If a report contains both conditional styles and style variables, the style variables are applied first and then the conditional styles are applied.