Conditional formatting is just what it says: formatting a cell based on its contents, usually a value. You may want to have a specific color or font type for a specific range of values. Conditional Formatting used to have, in older versions of Excel, up to three format conditions in addition to the default “no format” condition. Starting in Excel 2007 you may use many other features of conditional formatting. This chapter explains most of these features.
When using the old versions Excel, all you had to do is go through the menu to Format=>Conditional Formatting and apply the rules. As mentioned above, you could have up to three formats in a single cell or range of cells.
With the newer versions, starting in Excel 2007, conditional formatting became more comprehensive and allows you to be more creative.
The simplest way to apply a single rule is to select Conditional Formatting under the home Ribbon. Click on “Highlight Cells Rules” and choose one of the rules on the left. Excel has seven rules you may choose from. You also have a choice to create your own personalized rules. See Figure 5.1.
These rule choices are simpler to manipulate than in older versions of Excel. Now you can indicate with two clicks the format a cell ...