Using this tab, you can conditionally change the position of specific fields in the document, font color and background color of specific fields.

The List Options dialog box. The Conditional Appearance tab

The Format column shows the names of formats applied on the same conditions to the same target fields.

The Condition column shows the conditions on which the formats are applied to the target fields.

The Formatted fields column shows the target fields to which these formats are applied.

To define a new specific formatting with conditions, click Add on the tab toolbar, and the Edit conditional appearance item dialog box appears.

The Edit Conditional Appearance Item dialog box

The dialog box has the following three tabs:

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. The Format tab

For more detailed descriptions of conditional list formatting options, refer to List Conditional Formatting Options.
Example of Formatting
For example, the rows with documents where the amount is in Euro, we want to highlight in pink and show the text in all fields aligned to right. For this, proceed as follows:

On the Appearance tab, set the Background color parameter to the desired color (as on the screenshot above).
Select the Horizontal position parameter and select Align right option.
Open the Conditions tab.

The Edit conditional appearance item dialog box. The Conditions tab
4. Add the Currency field to table, set condition type to Equal to and select the value as EUR.
5. Add the Amount field , select Greater Than as condition, and enter the lower limit.
6. On the Formatted Fields tab, you can select specific fields to which the formatting will be applied. In our case, make no selections, and the formatting will be applied to all columns on the lines where Amount (EUR) >5.

The Edit conditional appearance item dialog box. The Formatted Fields tab
7. Click ОК to save the appearance settings and close the Edit conditional appearance item dialog box.
8. To apply these settings to the document list, click the Finish editing button in the List Options dialog box.

The Invoices list with the applied formatting
The list of documents will be generated according to these settings as shown in the screenshot below.

Saving the custom formatting settings

You can save several sets of the formatting settings and use them as needed.
Click the User-defined settings item properties button to add the conditional appearance settings to a set of custom settings.

The Custom Item Settings dialog box
Click OK to save the settings and close the Custom Settings dialog box. Click Finith Editing to close the dialog box with list configuration settings.
Then, you can view the name of the custom settings to the right between the toolbar and the document list (marked by red line).

The Grouping tab

To set groups, open the Grouping tab. Select fields for document grouping in the left pane of the dialog box and click Select on the tab toolbar. For example, we need to group documents by supplier company; for this, we select Company as grouping parameter.

The List Options dialog box. The Grouping tab
To apply these settings to the document list, click the Finish editing button. The list of documents will be generated according to the grouping settings.

The list of Invoices Received with documents grouped by company
The screenshot presents the result of grouping by company; you can click the node with supplier name to view the list of invoices received from this supplier.

Full-text search
Full text data search finds any information in the fields of the database tables and in content of the attached files.
It is possible to insert data navigation link in the input field of the search string. In this case the required form will be opened without data search. A navigation link to any infobase object may be obtained via the command in title of every 1C:Enterprise window.
A full text search index is not updated automatically in file mode and that's why from time to time it should be updated manually. If a full text search index is not actual (i.e. there exists not yet indexed data), then the "Update index" button becomes available in file infobase.
Search exampleResult
"Invoice 00016422"The "Invoice" document with number "00016422"
"Cheque 120000"Cheques with amounts 120000 and 120000,50 will be found
"Smith Purolator"All documents, created by Smith for company "Purolator", will be found
"Invoice Purolator"All documents "Invoice" for company "Purolator" will be found
"Purolator 07.05"All documents of company "Purolator", recorded on July 05 will be found
"Shoes"All occurrences of Item of type "shoes" will be found in order:
• White shoes (Product)
• Black shoes (Product)
• Receipt of goods and services # 00086822
• Sale of goods and services # 00016422
Tips:
If too much data has been found, then make the query more precise by adding additional conditions (date, amount, company name)
If not enough data has been found, then simplify the query by excluding some of the words
For precise search use:
Quotes - for search of exact match, for example: "mini cooper"
OR - for search of one of two words, for example "Purolator OR Fedex" - will find all occurrences of companies "Purolator" and "Fedex".
Brackets - to group expressions, for example, search "Smith (Purolator OR Fedex)" will find all documents, created by Smith for companies "Purolator" and "Fedex".
For search in synonyms too use "!", for example, search "!number" will find all documents where word "number" or "number" is present.
For "rough" search use "#", for example, "Fedex#2" will find all documents, containing words, which differ from word "Fedex" for one or two letters.
For search by the beginning of the word use "", for example, search "Fed" will find all documents, containing words that start from "Fed" - "Federal", "Fedex", etc.
See also: Full description of search expressions' format.

Fix-it

User-defined settings item properties Formatted fields	Save Appearance Settings Target Fields
Custom item settings Include in custom settings	Set of Appearance Settings Save as a set
Add new order item	Add Condition

Conditional Formatting Options for Lists
The Edit conditional appearance item dialog box appears when you click Add on the Conditional Appearance tab of the List Options dialog box.
The Edit conditional appearance item dialog box has the following three tabs:

Appearance: Use this tab to select the required formatting parameters and specify their values.
Conditions: On this tab, set the conditions for appling the formatting.
Formatted fields: Here, specify the "target" fields (columns) to apply conditional formatting.

The Edit conditional appearance item dialog box

Background color

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 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.

The Select Color dialog box

Text Color

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 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 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 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 rigtht: 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.

Format

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 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:

Number: for selecting formats of numbers
Date: for choosing date presentation
Boolean: for selecting presentation of Boolean values

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.

The Number tab

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:

3 - to represent 123456789 as 123 456 789.
3, 2 - to represent 123456789 as 12 34 56 789
3, 2, 0 - works the same as 3, 2. The value is a sequence of comma-separated numbers telling the format function how many digits have to be in each group from right to left. The format function uses only the first two numbers of the parameter. The first number of the parameter defines how many digits go in the first (rightmost) group of the number. If the second number of the parameter is not specified, the rest of the number's digits won't be grouped. If the second number of the parameter is set to 0, all number's digits will be split into groups of the same size (the one that set by the first number of the parameter). If the second number is not 0, it will define the size of all groups except for the rightmost one.

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:

0 - to show negative 1.1 as (1.1)
1 - to show negative 1.1 as -1.1
2 - to show negative 1.1 as - 1.1
3 - to show negative 1.1 as 1.1-
4 - to show negative 1.1 as 1.1 -

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-- 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:

14.06.23 (dd.MM.yy) - day, month with leading zeros, year without century.
14.06.2023 (dd.MM.YYYY) - day, month with leading zeros, year with century.
14.6.23 (d/M/yy) - day, month without leading zeros, year without century.
2023-06-15 (yyyy-MM-dd) - year with century, day and month with leading zeros.

Use the Local date format (DLF) field to specify the local date and time format:

6/14/2023 (D) - day and month without leading zeros and year with the century.
June 14, 2023 (DD) - Long date (month is spelled out).
6/14/2023 11:59:31 AM (DT) - Date and time time.
June 14, 2023 6/14/2023 (DDT) -
11:59:31 AM (T) - 12-hour time presentation; It is only valid for languages supporting this time format.

In the Blank Date Presentation (DE) field choose one of the following options to be used if there is no date:

"-"
No date
Empty Date

The Example fields allows you to preview the date formatted using the specified options. A text box at the bottom of the dialog box displays the resulting format string.

The Boolean tab

Use the Boolean tab to specify the format of 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.

Mark negatives

If a check box for this parameter is selected, and Yes is selected as value, the negative amounts or quantities will be specially marked. You can select a background color and font color for entire rows with negative values or for particular fields by using the Select Color dialog box. Also, you can set up format for presenting negative values by using the Format string wizard dialog box.

Unfilled mark

This formatting parameter controls how the text is alighned 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 rigtht: To align the text in the field to the right side.

Text

This formatting parameter allows you to subsitute some of the field values. Click in the Value column to open the drop-down list of options:

String: To enter an auxilary string to be shown as the values of specific fields (defined by conditions).
Data composition field: Se3lecting 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 specific conditions are met.
No: To hide the list items on specific conditions.

Accessibility

This formatting parameter controls whether the fields are accessible. Click in the Value column to open the drop-down list of options:

Yes: To make the fields accessible on the specified conditions.
No: To make the fields disabled on the specified conditions.

Show