Microsoft® Office Excel® 2007 Plain & Simple

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 ...