Conditional Formatting Dialog Box

You can use the Conditional Formatting dialog box to add conditional formatting to values of the selected field or to geographic map markers. This topic describes the options in the dialog box.

Designer displays the Conditional Formatting dialog box when you select a field or geographic map in a report and then select Conditional Formatting Conditional Formatting button in the Home or Format ribbon, or right-click the field or geographic map and select Conditional Formatting from the shortcut menu. Designer provides you with different options in the dialog box for adding conditional formatting for the values of a field or for geographic map markers.

When you use the Conditional Formatting dialog box to add conditional formatting to values of a field, Designer displays the following options in the dialog box:

Conditional Formatting dialog box for a field

Condition

This box lists the conditions that you add to define the conditional formatting.

Add button
Select to open the Edit Conditions dialog box to add a new condition.
Edit button
Select to edit the specified condition.
Remove button
Select to delete the specified condition.
Priority
- High
  Select to move a condition up for a higher priority.
- Low
  Select to move a condition down for a lower priority.

Format

You can specify the formatting to apply to the field values that satisfy the selected condition in this box.

Font
Select the font face of the values.
Border
Select the border line style of the values.
Size
Specify the font size of the values.
Bold
Select to apply bold formatting to the values.
Italic
Select to italicize the values.
Underline
Select to add a horizontal line under the values.
Foreground Color
Specify the foreground color for the values. To edit the color, select the color indicator and select a color from the color palette, or type the hexadecimal value of a color (for example, 0xff0000) in the text box.
Background Color
Specify the background color for the values.
Sample Text
This box displays a preview sample of your selection.
Blinking Text
Select to blink the values.
- Duration
  Specify how long it takes the field values to complete the transition from the foreground color to the transparent color, in seconds.

Select to apply your settings and close the dialog box.

Cancel

Select to close the dialog box without saving any changes.

Help

Select to view information about the dialog box.

When you use the Conditional Formatting dialog box to add conditional formatting for geographic map markers, Designer displays the following options in the dialog box:

Conditional Formatting dialog box for geographic map

Geographic Map

This box lists all the group levels in the geographic map. Select a group level to edit conditional formatting for its markers.

Condition

This box lists the conditions that you add to define the conditional formatting.

Add button
Select to open the Edit Conditions dialog box to add a new condition.
Edit button
Select to edit the specified condition.
Remove button
Select to delete the specified condition.
Priority
- High
  Select to move a condition up for a higher priority.
- Low
  Select to move a condition down for a lower priority.

Marker

You can specify the settings to apply to the markers that satisfy the selected condition in this box.

Image
Specify the image of the markers. You can type the URL for a web image or select Browse to specify a local image.
- Width
  Specify the width of the foreground image.
- Height
  Specify the height of the foreground image.
Shadow
Designer displays this option only when the geographic map applies one of the Google Maps types. Type the URL for a web image or select Browse to specify a local image as the shadow image of the markers.
- Width
  Specify the width of the shadow image.
- Height
  Specify the height of the shadow image.

Constrain Proportions

If you select this option, when you set the width or height of the marker image/shadow, Designer adjusts the other accordingly in a certain proportion.