Highlight data using a conditional style

Add conditional styles to your report to better identify exceptional or unexpected results. A conditional style is a format, such as cell shading or font color, that is applied to objects if a specified condition is true.

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.

Note: Conditional styles and conditional data formatting do not work on chart axis labels. If you apply a conditional style or conditional data formatting to a chart axis, only the first style defined is applied.

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.

Tip: The Return Quantity by Order Method sample report in the GO Data Warehouse (analysis) package includes conditional highlighting.