Microsoft® Excel® 2010 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.

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

• Highlight Cells Rules Formatting you apply to cells that stays “asleep” until the values (numeric or text) the cells contain achieve the specified state. Click Greater Than, Less Than, Between, Equal To, Text That Contains, A Date Occurring, or Duplicate Values to display a dialog box where you can ...