Page 194 - Excel 2013 All-in-One For Dummies

176 Conditional Formatting
Formatting with the Quick Analysis tool
Excel 2013’s new Quick Analysis tool enables you to apply various types of conditional formatting to selected cell ranges. Figure 2-22 illustrates how this works. For this figure, I selected the cell range E2:E12 containing a copy of the range of values from 6 to 1 and 1 to 6 before clicking the Quick Analysis tool that routinely appears in the lower-right below the last selected cell.
As soon as you select the Quick Analysis tool, the Formatting tab is auto- matically selected with its conditional formatting option buttons (Data Bars, Color Scale, Icon Set, Greater Than, Top 10%, and Clear Format) displayed. You can then use Live Preview to sample how the selected data would appear in different conditional formats. When you see one you like, you can then apply it by clicking the particular conditional formatting option button.
Identifying particular values or text entries in a cell range
The options attached to the Highlight Cell Rules and Top/Bottom Rules items on the Conditional Formatting button’s drop-down menu enable you to specify a particular type of formatting when certain conditions are met.
Figure 2-22:
Using the Formatting tab’s options on the Quick Analysis tool’s palette to preview conditional formatting applied
to a cell selection.