Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Chartless Visualization Techniques
As shown in Figure 4-9, the result is essentially a mini-chart within the cells you selected. Also note
that the Data Bars category, by default, accounts for negative numbers nicely by changing the
direction of the bar and inverting the color to red.
Figure 4-9: Conditional formatting with Data Bars.
After you create your Data Bars, it’s easy to go back and change their colors. Highlight
the range of cells that contain the Data Bars, and then go up to the Home tab and select
Conditional Formatting Manage Rules. This opens the Rules Manager dialog box that ➜
lists all the conditional formatting rules applied to the highlighted range. Here, select
your Data Bar rule and click the Edit Rule button. The Edit Formatting Rule dialog box
appears, allowing you to change the colors for both positive and negative Data Bars.
Applying Color Scales
Color Scales fill each cell you’re formatting with a color, varying in scale based on the value in each
cell relative to other formatted cells. Excel essentially takes the largest and smallest values in the
selected range and determines the color for each cell.
To apply Color Scales to a range, do the following:
1. Select the target range of cells to which you need to apply the conditional formatting.
2. Click the Home tab and choose Conditional Formatting➜Color Scales.
As you can see in Figure 4-10, you can choose from a menu of Color Scales varying in color.
Figure 4-10: Applying Color Scales.