Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
New Formatting
Rule dialog box
Click New Rule in
the Conditional
Formatting list to
display the New
Formatting Rule
dialog box.
Select a Rule
Type list
‘Format only cells
that contain’ rule
type selected
Click ‘Format only
Edit the Rule
cells that contain’ in
the Select a Rule Type
area (New Formatting
Rule dialog box) to
change the ‘Edit the
Rule Description’ area.
relational operator
value 2
value 1
Format button
In the ‘Edit the Rule
Description’ area, click
the box arrow in the
relational operator
box (second text box)
to display a list of
relational operators,
and then select
greater than to select the desired operator.
Figure 2 – 49
Select the rightmost box, and then type
70 in the box in the ‘Edit the Rule Description’
area to enter the second value of the rule description (Figure 2 – 49).
What do the changes in the ‘Edit the Rule Description’ indicate?
The ‘Edit the Rule Description’ area allows you to view and edit the rules for the conditional
format. In this case, reading the area indicates that Excel should conditionally format only
cells with cell values greater than 70.
Format Cells dialog box
Fill tab
Click the Format
button (New
Formatting Rule
dialog box) to display
the Format Cells
dialog box.
If necessary, click
the Font tab. Click
the Color box arrow
(Format Cells dialog
box) to display the
Color gallery and
then click White,
Background 1
(column 1, row 1) in
the Color gallery to
select the font color.
desired font
Sample area
displays font
OK button
Click the Fill tab
(Format Cells dialog
box) to display the
Fill sheet and then
click the orange color in
column 5, row 5 to select the background color (Figure 2 – 50).
Figure 2 – 50
Search JabSto ::

Custom Search