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
- Right-click the currency or number field you want to format to bring up the shortcut menu.
- On the shortcut menu, click Highlighting Expert.
The Highlighting Expert dialog box appears.
- Click the Priority arrows to specify the priority for each new formula that you apply. See Setting highlighting priorities.
- In the Item editor area, select a comparison from the Value is list, and enter a numeric value in the adjacent box.
- In the Font color, Background, and Border lists, specify your formatting changes to the select field.
- Click OK to return to your report.