Modeling with Rational Functions — Unit test

Question 651 • Crowley Credit Recovery Algebra II B

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

Answer

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

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

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

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

Explanation

Open the Conditional Formatting Rules Manager dialog box and find the rule you want to change. Edit the cell range shown in its Applies To section, then apply the change. You do not need to delete and recreate the rule; clearing rules would remove formatting rather than adjust its range.

AI-written and checked against the verified answer.

More from this Course

Unit Test

Assignment

Instruction