Skip to main content
Apply default and conditional formatting to rows and columns in the data grid.

​
Row Format

Open row format dialog from the data grid menu.
1

Open Format dialog

Open the data grid menu and click Format.The Format dialog opens.
2

Add conditions

Create conditions used by conditional formats.
  • In the Conditions section, click New Condition
  • Enter Condition Name
  • Define condition rules using fields or formula columns
  • Condition rules work like filters
3

Set default format

Set the default style for rows.
  • In the Default Format section, set Foreground Color
  • Set Background Color
  • The default is no color
4

Add conditional formats

Add formats that apply when conditions match.
  • In the Conditional Formats section, click Add Conditional Format
  • Select a condition
  • Set Foreground Color
  • Set Background Color
  • Check the preview box
5

Reorder conditional formats

Change the priority of conditional formats.
  • Drag the drag icon to reorder formats
  • The first matching rule is applied
6

Save

Save the format settings.
  • Click Save
  • Formatting is applied to the data grid

​
Column Format

Open column format dialog from the column menu.
1

Open Edit Column dialog

Open the column menu and click Edit.The Edit Column dialog opens.
2

Open Format tab

Click the Format tab.Column format settings are displayed.
3

Configure format

Configure conditions, default format, and conditional formats.The settings are the same as row format, but apply only to the selected column.
4

Save

Save the column format settings.
  • Click Save
  • Formatting is applied to the selected column

​
Color Selection

Choose colors for foreground and background.
1

Open color selector

Click Foreground Color or Background Color.The color palette dialog opens.
2

Select a color

Select a color.
  • Choose from predefined colors
  • Enter a custom color
  • Use the color picker
Conditional formats are applied using the first matching rule. Reorder rules to control priority.