Create a formatting rule

Application: Spreadsheet Home Edition macOS

There is no limit to the number of rules you can create. The most recently created rule has the highest priority over other rules on the sheet.

To create a conditional formatting rule for a range of cells, follow these steps:

1.Open the Create formatting rule window in one of the following ways:

•On the Home tab, in the Data group, click t_home_formatting_conditional Create formatting rule, or click the arrow to the right of this button and select Create formatting rule from the drop-down menu.

•On the Data tab, click t_home_formatting_conditional Conditional formatting or click the arrow to the right of the button and select Create formatting rule from the drop-down menu.

•Right-click any cell and select Create formatting rule from the context menu.

2.In the Apply to range box, enter the range address manually or click select_cells Select values to select the required range in the document itself, then click the button again to insert the address into the box.

3.In the Highlight block, configure the formatting rule:

Rule	Logic and features of operation
Unique values	The values in the cells are compared taking into account the data types: logical, string, number. The number format set for the cell is not taken into account. When comparing cells with formulas, only the result of the formula calculation is taken into account. Cells with the values FALSE and 0 are not considered equal, as they belong to different types. Empty cells are neither unique nor duplicate. When comparing text, case and spaces are taken into account.
Duplicate values
Top 10 values	You can specify the number of values to which formatting will be applied. The number is specified as an absolute value or as a percentage of the total number of cells in the range. In the latter case, you need to select the Percent checkbox.
Bottom 10 values
Values	Formatting is applied to a cell in a range if the value in it meets the condition specified by the criterion. The criterion can be a number or the address of a cell containing a value or formula. Formulas containing named ranges are not supported.
Date	When working with dates, Sunday is considered the first day of the week. Please take this into account when creating rules with conditions such as Last week, This week, Next week.
Text	Formatting is applied to a cell in a range if the text in it meets the condition specified by the criterion. The criterion can be text or the address of a cell containing text.
Cells using formula	Formatting to a range is only applied if the result of the specified formula calculation is TRUE or 1. Formulas containing named ranges are not supported.

4.In the Formatting block, select the formatting style that will be used for cells when the rule is applied.

5.Click OK.

Was this helpful?

Yes