Changing How Conditional Formatting Rules Are Applied

Excel 2007 enables you to create more powerful conditional formatting rules, but that’s not the only new trick in your conditional formatting bag. In prior versions of the program, when Excel found a condition that applied to your cell data, it stopped checking. That meant if you had one rule that formatted values of more than 1000 as bold text and another that formatted values of more than 1500 as italic text, the value 1600 would be formatted according only to the first rule applied.

In Excel 2007, you can decide whether Excel should stop after it finds a rule that applies to your data or continue to check other rules. You can also change the order in which Excel checks your conditions to control how Excel applies the rules. Rule order only matters 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 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 you want to change.

  6. Select the Stop If True box.

  7. Click OK.

    Stop when a Condition Is Met

Change the Order of Conditions

  1. Select the cells that contain the rules 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 you want to change.

  6. Follow either of these steps:

    • Click the Move Up button to move the rule one place higher in the order.

    • Click the Move Down button to move the rule one place lower in the order.

  7. Click OK.

    Change the Order of Conditions
    Change the Order of Conditions
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.117.71.211