How can a user change the range of cells that a Conditional Formatting rule applies to? 1. Clear the rule first and reapply it as it cannot be modified.
2. In the Conditional Formatting Rules Manager dialog box, edit the cell range for the rule in the Applies To section.
3. Clear all rules that have been applied to the worksheet or selected range by clicking on the Clear Rules button.
4. Right-click the cell range and select Update Conditional Formatting Rule from the menu list.