Microsoft Office Tutorials and References
In Depth Information
Verifying Formulas Using Range Finder
5
Tap or 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 – 48).
Preview area shows
selected font and fill
options
OK button
Figure 2 – 48
6
Tap or click the
OK button (New
Formatting Rule
dialog box) to assign
the conditional
format to the
selected range.
Tap or click
anywhere in the
worksheet, such as
cell A18, to deselect
the current range
(Figure 2 – 49).
conditional formatting
applied to cells containing
number greater than 70
Figure 2 – 49
 
Search JabSto ::




Custom Search