Условное форматирование

Use Conditional Formatting to define range-based conditions that determine which cell style will be applied to each cell in a given range based on its contents.

The cell style corresponding to the first condition that evaluates to true is applied. Cell styles applied through Conditional Formatting override cell styles applied manually using the Formatting Bar or the Styles sidebar.

You can enter several conditions that query the cell values or results of formulas. The conditions are evaluated from first to the last. If Condition 1 is true based on the current cell contents, the corresponding cell style is applied. Otherwise, Condition 2 is evaluated to determine if its corresponding style will be applied. If none of the conditions match cell contents, then no changes are made to the cell format.

Условные форматы не перезаписывают стили ячеек и прямое форматирование, применяемое вручную. Они сохраняются как свойства ячейки и применяются, когда ячейка не соответствует никаким условиям или при удалении всех условных форматов.

Диапазон ячеек

Диапазон

Defines the range of cells concerned by the conditional formatting. Click on the Shrink button to minimize the dialog box. Click again on the button to come back to the dialog box once the range is selected.

Condition list

List of the conditions defined for the cell range in order of evaluation. You can define as many conditions as you want.

Up

Increase priority of the selected condition.

Вниз

Decrease priority of the selected condition.

Добавить

Adds the condition to the condition list.

Удалить

Deletes the condition from the condition list.

Condition list entries

Specify if conditional formatting is dependent on one of the entry listed on the drop down box.

Apply Style

Select the cell style to apply when the condition is verified. Select New Style to open the Cell Style dialog and define the style properties.