Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
4
New Formatting
Rule dialog box
Click the OK button
(Format Cells dialog
box) to close the
Format Cells dialog
box and display the
New Formatting
Rule dialog box with
the desired font
and background
colors displayed in
the Preview box
(Figure 2 – 51).
Preview box displays
format assigned
to cell in selected
range if value in cell
is greater than 70
OK button
Figure 2 – 51
5
Click the OK button to
assign the conditional
format to the selected
range.
Click anywhere in the
worksheet, such as
cell A18, to deselect
the current range
(Figure 2 – 52).
Excel displays numbers
greater than 70 in range
D4:D12 with an orange
background and white
font color
Figure 2 – 52
 
Search JabSto ::




Custom Search