...
- Appearance: Use this tab to select the required formatting parameters and specify their values.
- Conditions: On this tab, set the conditions for applying the formatting.
- Formatted fields: Here, specify the "target" fields (columns) to apply conditional formatting.
The Edit conditional appearance item dialog box
...
This option allows you to select a specific background color for target fields (or all fields) on defined conditions.
Click in the Value column, then click 
(that appears to the rignt right in the field) to open the Select Color dialog box. In the dialog box, you can select the background color to be applied on conditions specified on the Conditions tab to the target fields specified on the Formatted Fields tab. Also, you can view the colors assigned to other elements of user interface and choose to apply such colors.
The Select Color dialog box
...
This parameter allows you to change the text color and background color for toolbar buttons, dialog boxes, fields under editing,
Click in the Value column, then click (that appears to the rignt right in the field) to open the Select Color dialog box. In the dialog box, you can select the text color to be applied on conditions specified on the Conditions tab to the target fields specified on the Formatted Fields tab. Also, you can view the colors assigned to other elements of user interface.
Font
This parameter can be used to change the font of specific fields once defined conditions are met. Click in the Value column, then click (that appears to the rignt right in the field) to open the Select font dialog box. You can specify the font, size, and select additional emphasis option (Bold, Italic, Underscore, or Strike-out). 
The Select Font dialog box
In the Preview box in the lower part of this dialog box, you can view an example of text with the selected font options.
Horizontal position
This formatting parameter controls how the text is alighned aligned within the field. Click in the Value column to open the drop-down list of options:
- Align left: To align the text in the field to the left side.
- Align rigthtright: To align the text in the field to the right side.
- Align center: To align the text in the field symmetrically with respect to center.
- Justify: To align the text to both the left and right sides by adding extra spaces as needed.
...
This parameter allows you to change formats for specific data types: Number, Date, and Boolean.
Click in the Value column, then click (that appears to the rignt right in the field) to open the Format string wizard dialog box. 
The Format string wizard. The Number tab (general view)
The wizard includes the following three tabs:
...
Click the tab that you need and specify the data format. The Example fields allows you to preview the data formatted using the specified options. A text box at the bottom of the dialog box displays the resulting format string.
If you leave some of the fields blank, the default values will be used.
When you click OK, the format string is recorded to the Format property.
You can edit the format string in the text box manually.
...
In the Length field, you can specify the total number of digits displayed for both integer and fractional parts. Rounding in the fractional part is performed according to the 1.5 as 2 rule. If this parameter is selected, the Precision parameter is required (otherwise fractional part will not be displayed).
Use the Precision field to specify the number of digits in the fractional part. The source number is rounded according to the 1.5 as 2 rule.
Shift. This parameter define decimal shift: positive for left, negative for right. In other words, the source number is multiplied or divided by 10*C, where C is the absolute value of this parameter.
You can use the Shift (NS) field to represent for example large amounts in thousands or millions. In other words, the source number is multiplied or divided by 10**C, where C is the absolute value of this parameter (C can be a negative integer).
In the Decimal Separator (NDS) field, enter a symbol to be used for separating integer and fractional parts of numbers. Abbreviation in round brackets, NDS, is used to designate this type of formatting in the Format string.
Use the Group Separator (NGS) field to enter a symbol to be used as a group separator of the groups of digits in the integer part of a number. If you specify a blank string, or a simple space, a nonbreaking space will be used as a separator.
Select the Output Leading zeros check box if you want to display zeros in front of numbers that takes less positions than Length - Precision.
Use the Presentation of zero (NZ) field to specify a string that represents a zero number. If not specified, the zero number is not shown (shown as a blank string). The following options are available: "-", Zero, Empty, Absent. Not applicable to numeric input fields.
Use the Grouping field (NG) to define how to group number's digits. The following options are available:
...
If the parameter contains more than two number, they are ignored.
Use the Negative number presentation (NN) field to specify how negative numbers should be presented. The following options are available:
...
In the Number formatting template (NF) field, select the template to be used as number format. The template is not applied to number 0.
Use the N character as the default value.
The screenshot below presents an example of number formating-- formatting – a sample is shown in the lower part of the dialog box.
The text box at the bottom contains a format string to be used by the Format function of the application. 
The Format string wizard. The Number tab (Format string)
The Example fields allows you to preview a number formatted using the specified options. A text box at the bottom of the dialog box displays the resulting format string. If you leave some of the fields blank, the default values will be used.
The Date tab
You can use the Date tab to specify the formats to be used for dates and time. 
The Format string wizard. The Date tab
Use the Date format (DF) field to specify the format of date presentation. You can select from the following options:
...
Use the Boolean tab to specify the format of boolean Boolean values: False and True. 
The Format string wizard. The Boolean tab
Use the Boolean presentation. True field to select how True will be designated: True, Yes, Included.
Use the Boolean presentation. False field to select how False will be designated, you can select from the following options: False, No, Disabled.
To apply the formatting select the corresponding check boxes.
...
This formatting parameter allows you to subsitute substitute some of the field values. Click in the Value column to open the drop-down list of options:
- String: To enter an auxilary auxiliary string to be shown as the values of specific fields (defined by conditions).
- Data composition field: Se3lecting Selecting this option opens the Select fields dialog box from which you can choose the fields which values will be shown in list's specific fields (defined by conditions).
The Select Data type dialog box
Visibility
This formatting parameter controls whether the fields are visible. Click in the Value column to open the drop-down list of options:
- Yes: (Default option) To make the list items visible oncw once specific conditions are met.
- No: To hide the list items on specific conditions.
...
This parameter is the symbol that is used for separation of multiple values. You can replace the symbol with another one directly in the Value column.Anchor
Раздел без номера
Working with the item list
Full-text search
Fix-it
Conditional Formatting Options for Lists