The Cross Table Condition Editor has some differences from the standard Condition Editor. In particular, when writing expressions within conditions, there are semantic differences due to the addition of special variables such as values, tags, tooltips, and hyperlinks.

A value variable contains the value of a crosstab cell and can be used to calculate a condition.

tags > 50

In other words, if the crosstable cell value is greater than 50, the condition is true and the formatting set in the condition is applied to the cell.

The tag, tooltip, and hyperlink variables contain the computed values of the tag, tooltip, and hyperlink properties. For example, you can specify the name of a product in the Tag property of a cross table cell.

{Products.ProductName}

Suppose you want to highlight in red the cells in the cross table where coffee products are described. This can be achieved by setting the format and using the following conditions:

tag == “coffee”