Microsoft Office Tutorials and References
In Depth Information
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 conditional formatting features in Excel 2013 are powerful and easy to use.
Excel 2013 offers five flavors of formatting features you can use for your conditional
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 specify the appropriate criteria.
Top/Bottom Rules Selected formatting applied to all cells in a range that are
greater than or less than a given threshold. Click Top N Items, Top N %, Bottom N
Items, Bottom N %, Above Average, or Below Average to display a dialog box where
you can specify the appropriate criteria.
Data Bars Gradient ills of color within cells. The bars’ lengths indicate the values
in the cells relative to all other adjacent cells formatted using the same conditions.
Choose from a number of different colors, based on the current theme.