Excel 2010 Conditional Formatting

Application: Excel 2010
Conditional formatting is a way of visually analyzing sets of data. Cells can be highlighted by pattern or color for criteria set in the rules.  Criteria can be high or low values, top or bottom numbers in a set, duplicate or single items, cells containing certain information, and even formula based. In Excel 2010, conditional formatting has been improved to include more icon sets, more options for data bars, and formatting across worksheets in a workbook.
Apply Conditional Formatting 1.    Select the data to apply conditional formatting. 2.    On the Home tab, in the Styles group, click the down arrow under Conditional Formatting. 3.    Select from the following: ·      Highlight Cells Rules-after selecting rule type (greater than, less than, = to, etc.) a dialog box will appear so that determining values can be entered. ·      Top/Bottom Rules -after selecting rule type (top 10, top 10%, bottom 10, bottom 10%, etc.) a dialog box will appear so that determining values can be entered. ·      Data Bars-choices include both solid and gradient fill patterns and colors. ·      Color Scales-choices include both two and three color scales. ·      Icon Sets-various types of icon patterns are offered. ·      New Rule-various rule types, format styles, value fields, and color options are available. To manage or clear rules, click the down arrow under Conditional Formatting  and select Manage Rules or Clear Rules.  For more information about conditional formatting in Excel 2010, visit the Microsoft Office article Add, change, find, or clear conditional formats.