Conditionally formatting fields using the Highlighting Expert

Using the Highlighting Expert, you can conditionally format only currency and number fields.

To conditionally format fields using the Highlighting Expert

1. Right-click the currency or number field you want to format to bring up the shortcut menu.

2. On the shortcut menu, click Highlighting Expert.

   The Highlighting Expert dialog box appears.

   

3. Click the Priority arrows to specify the priority for each new formula that you apply. See Setting highlighting priorities.
4. In the Item editor area, select a comparison from the Value is list, and enter a numeric value in the adjacent box.
5. In the Font color, Background, and Border lists, specify your formatting changes to the select field.
6. Click OK to return to your report.