Sheet Setting - Format

In the Format tab, you can configure formatting settings such as text color and background color for the entire sheet and specific rows (records).

You can change the default formatting settings (text color and background color) for row display in the sheet. Click the Add New Conditional Format [*] button to add conditional formatting for records that match specific conditions.

In conditional formatting, select a display condition from the Display Condition Selection List [A] and choose the Text Color [B] and Background Color [C] for rows to be displayed when that condition is met. The actual row display is previewed in "Sample Text".

In the initial setup phase, no display conditions are created, so launch the dialog from the Create New Condition [D] menu to create display conditions.

If display conditions have already been configured, you can edit existing display condition settings from Manage Conditions [E].

When multiple conditional formats are set, conditions are compared in order from top to bottom, and the format of the first matching condition is selected as the format for that row. If no conditional formatting display conditions match, the default format is selected.

Conditional formatting can be deleted by clicking the [x] button.

Create New Display Condition

In the Create New Display Condition dialog, you create a new named display condition. By constructing conditional expressions using record column value information, it determines whether records match the display conditions.

Display conditions consist of multiple condition rows and condition groups. Condition groups can contain condition rows and condition groups nested within them, and you can change the comparison mode within the group (match all or match any).

• Condition Name [A] - Set a name to identify the content of the display condition

• Condition Comparison Mode [B] - When there are multiple condition rows/groups below, you can select "match all conditions" or "match any condition" as the comparison mode.

• Condition Row [C] - Set expressions to compare record column values. Can be deleted by clicking the [x] button.

• Condition Comparison Column [D] - Select the target column to compare from the dropdown list of columns in the sheet

• Condition Comparison Operator [E] - Specify the operator to use when comparing columns. Available operators change based on the column data type

• Condition Comparison Value [F] - Enter the value to compare with the column value. Multiple values can be specified separated by commas. When "Compare with column value" is selected in the comparison target selection menu, you can select another column in the sheet.

• Condition Comparison Target Selection Menu [G] - Determines how to select the values to be used in condition comparison

  • Enter comparison value directly - Directly specify and enter values from the input form on screen

  • Compare with column value - Select another column in the sheet and use its value as the condition comparison value

  • Select reference value - Display the reference value selection dialog to use reference values. For reference value selection, see "Reference Value".

• Add Condition Row [H] - Add a new condition row to the display condition.

• Add Group [I] - Add a condition group to the display condition.

Manage Display Conditions

In the Manage Display Conditions dialog, you can view details of existing configured display conditions, and create new ones, edit, and delete them.

• Display Condition List [A] - Names of configured display conditions are displayed in a list. You can select display conditions and edit their content

• Display Condition Controls [B] - You can reorder display conditions, and create new ones or delete them.