The Highlighting Expert enables you to apply conditional formatting to all types of report fields (Number, Currency, String, Boolean, Date, Time, and Date and Time fields). With the expert, you format the selected field either by specifying a condition based on that field’s value, or by specifying a condition based on the value of a different report field.
Think of the Highlighting Expert as a formula editor that runs the following equation: If condition is True, then apply these formatting specifications. For this purpose, the dialog box is divided into two sections, the Item list section, which displays the items, and the Item editor, which enables you to set the condition and the resulting format of the selected item in the Item list. The Item editor includes a Sample view to illustrate the formatting specifications applied.
You can create multiple items with this dialog box. Each item appears in the Item list. You can use the Remove button to delete items as well as use the Priority arrow buttons to specify the order of priority for each item.
Highlighting Expert Features
When used for conditional formatting, the Highlighting Expert allows you to do the following:
Modify several attributes at once, without writing a formula
Format font style, background color, font color, and border style
Format a field based on its own values or the values of another field