Microsoft® Office Excel® 2007 Plain & Simple

Formatting a Cell Based on Conditions

Another way you can make your data easier to interpret is to change the appearance of your data based on the value in a cell. This kind of formatting is called conditional formatting because the data must meet certain conditions to have a format applied to it. For example, if you use a worksheet to track your customers’ credit lines, you could have a customer’s outstanding balance appear in red if they are within 10 percent of their credit limit.

Excel 2007 improves upon the conditional formatting capabilities of previous versions by enabling you to create an unlimited number of conditions (you were previously limited to three), allowing more than one condition to be applied to a cell, and making it easier ...