Creating text or numeric comparisons using conditional style
Use this procedure to make comparisons
between fields that use numeric data or text.
Note: Smart links through conditional style is not supported in H5.
- Open a program.
- Select Tools > Personalize > Conditional Styles.
- Click New.
-
Select the field from the Target Field list. You can select Use full field ID of list to use the 6-character name
of the list column where you want to apply the conditional style. The option is available
only if the selected target is a list column.
Note: When working with Gantt chart data, set the value of the Target Field to Gantt Chart.
- From the Select condition type list, select either Numeric or Text.
-
Specify this information:
- Operator for comparison
- Select the operator from the list.
For text and numeric data, you can select the standard comparison operators, such as equal to (=), greater than (>), greater than or equal to (>=).
For text comparisons, you can select Contains, Starts with, and Ends with.
- Field or Specific Value
- Select Field if
you are comparing the target field to another field. In the next box, select the
field to compare to the target.
Select Specific Value if you are comparing the target field to a value. In the next box, specify the value to compare to the target.
If the data contains leading blank spaces, you can remove them by selecting Trim blank spaces.
Click the Add button (+) to add another condition, or click the Remove button (-) to delete an existing condition. - Click Next.
-
Format the display characteristics for the field:
- On the Color tab, change the color for the Field or Text. You can apply the color changes to an entire row by selecting Enable style for entire row.
-
On the Text tab, change the alignment and style. You can include your own
tooltip text. To display the default tool tip instead, select Show original value as
tooltip.
Note: If you require a translation for the tooltip text, use the translation icon to add your translated text.
-
On the Icon tab, select an icon to go with
the field.
Note: When working with Gantt Chart conditional styles, you can only apply Icon as the format.
-
On the Hyperlinks tab, select the Make field a hyperlink check box to create a
hyperlink for the field. Choose between a related option or a new link.
To open the link in a browser, select the Open link in external browser check box.
- Click Next.
-
Specify this information:
- Name
- Optionally, specify a name for the conditional style.
- Description
- Optionally, provide a description for the conditional style.
- Select the Activate check box for the conditional style to take effect.
- Click Finish.