Find cells that match a format

1. Click Find on the Edit menu.
2. Clear the Find what box.
3. Do one of the following:
   • If you want to specify format, click Options, click Format, and then set your options in the Find Format dialog box.
   • If you want to point to a specific cell format as an example, click the arrow next to Format, click Choose Format From Cell, and then click the cell.

   Note  The format for the search is displayed in the Preview box.

4. Click Find All or Find Next.

   Find All lists every occurrence of the item you are searching for and allows you to make a cell active by selecting a specific occurrence. You can sort the results of a Find All search by clicking a header.