## Highlighting Expert

The Highlighting Expert allows you to efficiently apply conditional formatting to currency and number fields. The Highlighting Expert is most commonly used for highlighting field values that are in some way distinguished from the other values in the report. For example, if you wanted to highlight the {customer.LAST YEAR'S SALES} field in red whenever the sales are greater than $25,000, you could specify in the Highlighting Expert that, if the value is greater than $25,000, a red background color is applied to the field. You can also use the dialog box to set conditional font color and border style.

Note: Think of the Highlighting Expert as an alternative to the Formula Editor. The Highlighting Expert essentially runs the following equation: If Condition is True, Then Apply These Formatting Specifications.

For this purpose, the Highlighting Expert is divided into two sections, the Item list section (which displays the formula), and the Item editor (which allows you to set the formula). The Item editor includes a Sample view to demonstrate the formatting specifications applied.

Here are some additional benefits to note:

- The Highlighting Expert can also be used for numeric/currency fields in Cross-tabs, as well.
- You can undo highlighting.
- You can also set highlighting priorities.

##### Item list

The Item list displays the highlighting formulas created for the currently selected field.

##### Priority

Use the Priority buttons in the Item List list of the Highlighting Expert to set the priorities for your formulas.

##### Remove

Use the Remove button to discard unwanted highlighting formulas for the currently selected field.

##### Remove All

Use the Remove All button to discard all highlighting formulas for the currently selected field.

##### Value is

Use this list to select a qualifier for your number of currency value. For example, you may choose to apply a red background color when the value contained in a field is equal to $25,000. In the Value is list, you determine the 'equal to' qualifier.

##### Field values

Use this text box to enter the currency value or numeric value to which you want to apply highlighting conditions. For example, you may choose to Highlighting Expert apply a red background color when the value contained in a field is equal to $25,000. In the Field values text box, you would type 25,000.

##### Font color

Use this list to select a font color for the number or currency value to which you want to apply a highlighting condition.

##### Background

Use this list to select a background color for the number or currency value to which you want to apply a highlighting condition.

##### Border

Use this list to select a border style for the number or currency value to which you want to apply a highlighting condition.

##### Sample

Shows a sample using the settings selected in the expert.

###### Related topics

Undo/Redo activities

Conditionally formatting fields using the Highlighting Expert

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com