Microsoft Office Tutorials and References
In Depth Information
Figure 8-40 Click Format in the Find And Replace dialog box to display the Find Format
You’ll find the Regional Sales.xlsx file with the other examples on the companion website.
When you click Choose Format From Cell, a small eyedropper appears next to the pointer
when you position it over the worksheet area. Click a cell that is formatted the way you
want, and the Find And Replace dialog box displays the word Preview* in the box that
otherwise displays the message No Format Set . After you set your formatting criteria, Excel will
not find any character strings you search for unless the formatting criteria also match.
Without a string, Excel searches for the formatting only. For example, choosing the formatting
of the selected cell—A3—in Figure 8-39 as the Find What criteria, clicking Find All would
result in the selection of all the matching cells on the current worksheet. Or if you search
for the word Sales and specify bold as a formatting criterion, Excel finds any cells
containing the word Sales , but only if it is displayed in bold type. The more formatting options you
set, the narrower the search.
Here are two things to watch out for. First, make sure the cell you use as an example does
not have any nonapparent formatting applied, such as a number format in a cell
displaying only text. Second, be sure to click Clear Find Format in the Format drop-down list
shown in Figure 8-39 to remove the formatting criteria after you’re finished. Otherwise, you
might not notice the word Preview* in the dialog box, and future searches could produce
un expected results.