Excel Data AnalysisLesson 51Free preview

Excel Manage Rules (CF)

This lesson is part of Excel · All levels

Summary

Conditional Formatting Rules Manager displays all the rules in the range along with the order of priority. You can add, change, delete, or move the rule position, as well as enable Stop If to prevent the next rule from being processed. Keeping priorities neat is important when many rules compete on the same cell.

Key points

Rules Manager opens up the list of CF rules and their scope
Priority determines which rule wins on the same format property
Stop If stops evaluating the rules under it
The rules can be moved up and down and applied to many sheets.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.