Adding Conditional Formats to Shape Map Areas

When the shape map areas are bound with data, you can add conditional formats to them, then when a specified condition is fulfilled, the format bound with the condition will be applied to the shape map areas automatically. This is very useful to highlight values that might need to be acted on by the end user.

To add conditional formats to the map areas:

In the Shape Map Editor, select the Conditional Formatting button on the toolbar, or select Menu > Format > Conditional Formatting. The Shape Map Area Conditional Formatting dialog appears.
Select the Add button below the Map Area Condition box. The Edit Conditions dialog appears.
Select the Add Condition button to add a condition line.
From the field drop-down list, select the field on which the condition will be based.
Choose the operator with which to compose the condition expression from the operator drop-down list.
Select next to the value box to specify the value of how to build the condition. You can also type in the value manually.
Select Add Condition to add more condition lines and define the logic between the condition lines.
To make some condition lines grouped, select them and select the Group button, then the selected condition lines will be added in one group and work as one line of filter expression. Conditions and groups together can be further grouped. To take any condition or group in a group out, select it and select Ungroup.
To adjust the priority of the condition lines, select it and select the Up or Down button.
To delete a condition line, select it and select the Delete button.
Select OK to save the condition.
The newly added condition is then displayed in the Map Area Condition box in the Map Area Conditional Formatting dialog.
In the Format box of the Map Area Conditional Formatting dialog, set the format which will be applied to the specified map areas when the specified condition is fulfilled, including the fill color, border color, border style, and border width.
Repeat the above steps to add more conditions and define the format for each condition.
To edit a condition, select the condition from the Map Area Condition box, select the Edit button, then edit the condition in the Edit Conditions dialog.
To adjust the priority of the conditions, select a condition and select the High or Low button.
To remove a condition and the corresponding format, select the condition from the Map Area Condition box and then select the Remove button.
When done, select OK to save and apply the settings.

Previous Topic Next Topic