Home 
Excel 2002 Format Find Similarly Formatted Cells
Search MS Office A-Z | Search Web Pages/ Design A-Z
Find Similarly Formatted Cells
- Choose Edit and Find. Click Options and the arrow beside the Format button and choose Format.
- Set the items you want to look for.
- Click OK and Find All in the Find And Replace dialog box.
- At the bottom of the box, a list will show the cells that match the formatting parameters you entered.