Highlighting Expert Dialog Box
The Highlighting Expert enables you to apply conditional formatting to all types of report fields (Number, Currency, String, Boolean, Date, Time, and DateTime 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. In other words, the expert enables you create the following formula: If the value of field X meets condition A, then apply the specified formatting to the field selected on the report.
This dialog box appears when you right-click a currency or number field object and select Highlighting Expert from the shortcut menu.
Item list
The Item list displays the highlighting formulas created for the currently selected field.
| Priority | Use the Priority buttons in the Item List of the Highlighting Expert to set the priorities for your formulas. |
| New | Use the New button to add a new highlighting formula. After you click New, specify the formula's values in the Item editor. |
| Remove | Use the Remove button to discard unwanted highlighting formulas for the currently selected field. |
Item Editor
The Item editor allows you to set the formula. The Item editor includes a Sample view to demonstrate the formatting specifications applied.
| Value of | Use the first drop-down list to choose the field the highlighting rule should apply to.
Use the second drop-down list to specify the condition. The default is "is equal to". Use the third drop-down list to enter the currency value or numeric value to which you want to apply highlighting conditions. |
| Font style | Use this list to select a font style for the number or currency value to which you want to apply a highlighting condition. |
| 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 Highlighting Expert. |