Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

You can only find the cells that exactly match the formatting based on the existing cell in Excel


View products that this article applies to.

Symptoms

When you use the Find and Replace commands to find formatting that is based on an existing cell in Microsoft Excel, only cells that exactly match the formatting are found.

For example, if the cell that the search is based on contains a top border, a left border, and a number formatted as a percentage, other cells that contain numbers formatted as percentages are not found, unless they also have matching top and left borders.

↑ Back to the top


Resolution

To work around this behavior, clear any formatting in the Find Format dialog box that you do not want to include in the search. To do this, follow these steps:
  1. In the Excel worksheet, click Find on the Edit menu.

    Note In Excel 2007, click Find & Select in the Editing group on the Home tab. Then, click Find.
  2. Click Format.
  3. Click Clear in the lower-right corner of any tab that contains unwanted formatting.

    Note If the Clear button is unavailable on the tab, no formatting from that tab is selected.
  4. Click OK.

↑ Back to the top


More information

To find or replace formatting that is based on an existing cell format, follow these steps:
  1. On the Edit menu, click Find.

    Note In Excel 2007, click Find & Select in the Editing group on the Home tab. Then, click Find.
  2. If the Format button is not visible in the Find and Replace dialog box, click Options.
  3. Click the arrow next to Format, and then click Choose Format From Cell.
  4. Click the cell that contains the formatting for which you want to search.
  5. Click OK.
  6. Click Find All in the Find and Replace dialog box.

↑ Back to the top


Keywords: KB283626, kbprb, kbexpertisebeginner

↑ Back to the top

Article Info
Article ID : 283626
Revision : 2
Created on : 1/12/2007
Published on : 1/12/2007
Exists online : False
Views : 257