Microsoft Office Tutorials and References
In Depth Information
Changing how conditional formatting rules are applied
Changing how conditional formatting rules are applied
Excel 2013 enables you to create powerful conditional
formatting rules and to control how those rules are applied. For
example, you can have Excel apply more than one conditional
format to a cell, so if you want to display a value of more than
1,000 in bold text and values that exceed a sales target with a
yellow background, you can define those conditions separately
and have Excel apply them both.
You can also decide whether Excel should stop after it finds a
rule that applies to your data or continue to check other rules.
Finally, you can change the order in which Excel checks your
conditions to control how Excel applies the rules. Rule order
matters only if you choose to have Excel stop after it applies a
rule.
Stop when a condition is met
1 Select the cells that contain the rule that you want to edit.
2 Click the Home tab.
3 In the Styles group, click Conditional Formatting.
4 Click Manage Rules.
5 Click the rule that you want to change.
6 Select the Stop If True check box.
7 Click OK.
2
3
4
1
6
5
7
Search JabSto ::




Custom Search