Page 200 - Excel 2013 All-in-One For Dummies

182 Conditional Formatting
By default, the Conditional Formatting Rules Manager dialog box shows all the rules assigned only to the current cell selection or table. To see all the conditional formatting rules in a particular worksheet or table, select its name from the Show Formatting Rules For drop-down list at the top of the dialog box.
A rule that appears higher in the Rule list box of the Conditional Formatting Rules Manager dialog box has a higher precedence and is therefore applied before one lower in the list. When more than one rule is true, what happens depends on whether or not the formatting applied by those rules conflict. When they don’t conflict (as when one rule formats the cells in bold italic and the other formats the cells with a light red fill), both formats are applied. However, when the formats conflict (as when one rule formats the cells with black fill and bright yellow text and the other formats the cells with yellow fill and black text), the rule with the higher precedence wins, and only its conditional formatting is applied.