Microsoft Office Tutorials and References
In Depth Information
Excel provides a way to find cells based on formatting in conjunction with other criteria,
and even to find and replace specifically formatted cells, regardless of their content. If you
click the Format button in the Find And Replace dialog box shown in Figure 8-39, the Find
Format dialog box shown in Figure 8-40 appears. This dialog box has two names—Find
Format and Replace Format—depending on whether you clicked the Format button that is
adjacent to the Find What text box or the one adjacent to the Replace With text box on the
Replace tab. Otherwise, the two dialog boxes are identical. You can select any number of
options in this dialog box and click OK when you finish to add them to your criteria.
Figure 8-39 Click Choose Format From Cell to use the formatting of a selected cell as search
If you click the arrow button next to the Format button to display the Format menu, you
can click Choose Format From Cell, as shown in Figure 8-39. Choose Format From Cell is
also available as a button at the bottom of the Find Format (or Replace Format) dialog box
shown in Figure 8-40.