Create a rule of the Regular highlighting type

Application: Spreadsheet Home Edition

To create a rule of the Regular highlighting type for a range of cells, follow these steps:

1.Select the range of cells for which you want to create a rule.

2.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 Regular highlighting command from the drop-down menu.

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

•Right-click any cell in the selected range and select Create formatting rule > Regular highlighting from the context menu.

3.In the window that opens, in the Apply to range box, the address of the previously selected range is filled in. If necessary, you can edit the address. To do this, enter it manually in the box, or click select_cells Select values to select a range in the document. When you select a range of data with the mouse, a tooltip appears showing the dimensions of the selected area. The tooltip is displayed as long as the left mouse button remains held down. Click Select values again to insert the address into the box.

formatting_conditional_create_highlight_window

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

Values	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 (other than 10) 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.
Date	Formatting is applied to a cell in the range if the date in it meets the condition. 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. For example, to visually highlight cells with future dates in column A, enter =A2>TODAY() on the Formula bar. Cells that meet this condition will be formatted according to the selected style:

5.In the Formatting block, configure the formatting settings that will be used on cells when the rule is applied. You can choose from a set of ready-made styles and a pane with formatting operations for customization. To reset the current settings to the default ones, click conditional_formatting_clear_button Clear formatting.

6.Click OK.

Was this helpful?

Yes