–Rule title. The title is generated automatically when the rule is created. In most cases, the rule type is used as the title. The exception is the Regular highlighting rule type, for which the name is selected based on a criterion (for example, Unique values, Top 10).

–The range to which the rule is applied. If the rule is applied to multiple ranges, they are separated by a semicolon, for example, "E2:E17;E23:E28".

–A thumbnail corresponding to the rule type.

–The icon in the rule title when the Stop subsequent rules option is enabled for it.

formatting_conditional_list

To see which range a rule applies to, hover your cursor over the rule in the list. The range will be highlighted on the sheet. To select the range, left-click the rule in the list. If the rule applies to a range on another sheet, when you click it, you will be switched to that sheet and the range will be selected.

Filter the list

By default, the Conditional formatting pane displays the complete list of rules contained in the spreadsheet. If there are a large number of rules, you can filter the list to make searching easier.

You can filter by two criteria: location or rule type.

To filter by rule location, click the drop-down list on the left at the top of the pane (default: Entire document) and select one of the following options:

–Entire document: The list displays rules for the entire document.

–This sheet: The list displays rules for the current sheet.

–Selected cells: The list displays rules for the currently selected cells. If the selected cells fall within only part of a rule’s range, the rule will still appear in the list.

formatting_conditional_filtering_location

To filter by rule type, click the drop-down filter list at the top right of the pane (default: All rules) and select the rule type you want to display in the list from the drop-down menu.

formatting_conditional_filtering_type

Was this helpful?

Yes