Microsoft Office Tutorials and References
In Depth Information
D ATA B ARS
1
Repeat Steps 1 to 3
listed under Conditional
Format.
l This is the selected
data.
A menu appears.
2
3
2
Click Data Bars.
A submenu appears.
3
Click the color data bar
you want to use.
l Excel applies the data bars to the cells you
selected.
Did You Know?
Excel provides you with several colors to choose
from when you add data bars to your worksheet.
You can select another color. Click the Home tab
and then click Conditional Formatting in the Styles
group. A menu appears. Click Data Bars and then
click More Rules. The New Formatting Rule dialog
box appears. Use the Bar Color field to select a new
color. Click OK.
Did You Know?
You can use color scales to conditionally format data.
Color scales use gradations of color. For example, if
you use Excel’s yellow and green color scale, yellow
represents lower values and green, higher values. To
apply a color scale, select the cells to which you
want to apply the scale, click the Home tab, click
Conditional Formatting, click Color Scales, and then
click the color scale you want to apply.
Chapter 3: Copy, Format, and More
73
 
Search JabSto ::




Custom Search