How to Conditionally Format your Worksheet in Excel 2007 Pt. 2
You can Read Part One Here
Data bars enable you to discern at a glance how large a value in one cell is relative to the values in other
cells. A data bar is a colored bar you place in a cell. The length of the bar represents the value of the cell
relative to other cells — the longer the bar, the higher the value. Excel provides you with several bars from
which to choose and you can design your own. Color scales and icon sets are similar to data bars,
except color scales use gradients of color to represent the relative size of the cell value, and icon
sets use icons to represent the relative size of the value.
Data bars, color scales, and icon sets all use rules to determine when to display what. You can use the
rules defined by Excel or you can create your own rules. At the bottom of the data bar, color scale, or
icon set menu, click More Rules to adjust rules.
Modify Rules
1. Repeat Steps 1 to 3 listed under Conditional Format from part one. A menu appears.
2. Click Icon Sets. Alternatively, you can click Data Bars or Color Scales. Each allows you to change the associated rules. A submenu appears.
3. Click More Rules. The New Formatting Rule dialog box appears.
4. Select a rule type.
5. Select a format style.
6. Select an operator.
7. Type a value or click in the cell that contains the value you want to use.
8. Select a type. Note: You can choose Number, Percent, Formula, or Percentile.
9. Select an icon style.
10. Click OK. Excel displays the results of your rule.
You can Sort by Cell Color, Font Color, or Icon. Right-click in any cell that has conditional formatting applied to it. A context menu appears. Click Sort and then select the appropriate sort option.
If you click Show Icon Only, Show Bar Only, or Show Color Only in the New Formatting Rule dialog box, Excel displays icons, bars, or color, but not the values in each cell.
