Question

How can a user change the range of cells that a Conditional Formatting rule applies to?

A: Clear the rule first and reapply it as it cannot be modified.

B: In the Conditional Formatting Rules Manager dialog box, edit the cell range for the rule in the Applies To section.

C: Clear all rules that have been applied to the worksheet or selected range by clicking on the Clear Rules button.

D: Right-click the cell range and select Update Conditional Formatting Rule from the menu list.

Answer 1

B

Step-by-step explanation:

Answer 2

B: In the Conditional Formatting Rules Manager dialog box, edit the cell range for the rule in the Applies To section.

Step-by-step explanation:

Conditional formatting rule: The term "conditional formatting rule" is described as a technique that allows an individual to apply formatting automatically, for example, data bars, colors, and icons, etc., to one or more than one cells on the basis of the cell value.

Example: If the value is more than $3000, color the cell blue.

In the question above, the correct answer is option-B.