Operation Manual

Formatting
Working with conditional formatting
13
Crystal Reports User’s Guide 277
2. In the Highlighting Expert, click New to create a new conditional formula
with default settings.
3. In the Item editor area, click the Value of list and select the field that you
want to base your condition on.
The field chosen here is the field upon which your condition is based; this
field need not be the field that is being formatted. To create a condition
based on the values of the field that is being formatted, select “this field”
from the list. To base your condition on a different report field, select it
from the list of available fields.
Note: The “Value of” list displays only those fields that you have added
to the report.
4. Select a comparison from the second list (is equal to, is less than, and so
on).
This comparative statement works as the operator in the conditional
formula created by the expert.
5. Complete the condition by entering the desired value in the box.
Note: If the field selected in the “Value of” list is not numeric, the text box
turns into a list of available values, from which you must select one.
6. In the Font style, Font color, Background, and Border lists, specify the
formatting changes that you want to apply to the selected field when your
condition is met.
7. Repeat steps 3 and 4 if you want to apply multiple highlighting conditions
to the selected field.
Note: You can use the expert’s Remove button to delete highlighting
formulas from the list.