5.1.1 Creating a Highlight
To apply a highlight to a table column, image, text element, chart, or crosstab, follow these steps:
1. Right-click the element you wish to highlight. (For a Table, right-click a data cell in column to which you want the highlight to be applied.)
2. Select 'Highlight' from the right-click context menu. This opens the 'Highlight' dialog box.

3. Click the 'Add' button. This opens the 'Name' dialog box.
4. Enter a name for this highlight, and click 'OK' to close the dialog box.
5. Repeat the previous steps to enter any additional highlights, and then follow the steps below for each individual highlight.
6. Select the highlight in the list that you want to edit.
7. In the 'Properties' panel, select the highlight format. The formatting is applied when the data meets the highlight condition (specified below):
a. Click the 'Foreground' color chip to set the text color.
b. Click the 'Background' color chip to set the fill color.
c. Click the 'Edit' button next to the 'Font' field to open the 'Font' dialog box. Make the desired font selections and press 'OK'. (Press 'Reset' to restore the original settings.)
Cell-based highlights take precedence over row-based highlights.
8. For a Table, select 'Apply to Row' if you wish to apply the specified formatting to the entire table row. Otherwise, the formatting applies only to the selected table column.
9. Click the 'Edit' button below the 'Conditions' box. This opens the 'Conditions' dialog box.

Note: To use aggregate fields in a highlight condition for a Freehand Table, first assign a 'Cell Name' to the aggregate field in the Freehand Table Editor. See Freehand Tables for more information.
10. Follow the steps below to specify the condition expression for this highlight:
a. Select the operand and type of comparison from the menus at the top of the dialog box, e.g., “[Company][is not][one of]”
For table highlights, the operand is one of the table column names. For text and image highlights, the operand is called 'value', which is the aggregate value associated with the element, as configured in the Data tab of the element's 'Properties' dialog box.

b. For table highlighting, select 'Value', 'Field', or 'Variable' from the 'Change Value Type' popup menu (triangle).
c. If you select the 'Field' option, in the adjoining menu, choose the table column for comparison. (The two columns will be compared row by row, and the specified highlight will be applied to every row where the condition holds true.)
d. If you select the 'Value' option, either enter the comparison value into the provided text field, or select 'Browse Data' to choose the comparison value from a list.
e. If you select the 'Variable' option, select one of the Input Components listed in the menu to provide the value at runtime. (See Dynamic Properties for further details.)
f. If you select the 'Expression' option, press the 'js'/'sql' button to select JavaScript or SQL syntax, and then press the 'Edit' button. This opens the Script Editor where you can enter your expression. (See Adding Property Script (Expressions) in Dashboard Scripting for details on using expressions.)
g. When you have fully specified the condition, click 'Append'.
h. To create a compound condition, repeat Steps a-g above, using the 'and' and 'or' operators to composite the conditions. See Modifying a Filter/Highlight Condition for more details.
i. Click 'OK' to exit the 'Conditions' dialog box and return to the 'Highlight' dialog box.
When you add a highlight to a table column or crosstab, the highlight condition is tested individually for each cell. When the condition is satisfied, the corresponding highlight format is applied to the cell or row (if 'Apply to Row' is selected).
You can use multiple highlights in combination to produce composite formats. For example, if you specify a red-foreground highlight for the condition “Discount is greater than 0,” and you also specify a bold font highlight for the condition “State is equal to NJ,” values which meet both conditions will appear highlighted in red and bold.
See Also
Adding Highlights to a Table, for information on the table 'Highlight' dialog box.
Adding Highlights to Text, for information on the text 'Highlight' dialog box.
Adding Highlights to an Image, for information on the image 'Highlight' dialog box.
Adding Highlights to a Chart, for information on highlighting charts.
Filtering Operators, in Data Mashup, for explanation of the operators.
Dashboard Scripting, for more sophisticated conditional formatting.
| << 5.1 Highlights | © 1996-2013 InetSoft Technology Corporation (v11.5) | 5.1.2 Modifying a Filter/Highlight Condition >> |