Microsoft® Office Excel® 2007 Inside Out

Formatting Conditionally

Conditional formats respond to the contents of cells. They are almost always applied to groups of cells, often rows or columns of totals, if not entire tables. Click Home, Conditional Formatting to display the menu shown in Figure 9-20.

Figure 9-20. The revamped conditional formatting features in Excel 2007 are more powerful and easier to use than previous versions.

Office Excel 2007 offers five flavors of formatting features you can use for your conditional creations:

• Highlight Cells Rules. Formatting you apply to cells that ...