EXCEL TIPS AND TRICKS 2

To Find Text Formatted Using a Specific Format

1. Click the Home tab on the Ribbon.
2. In the Editing section, click Find & Select.
3. Click Find.
4. In the Find and Replace dialog box, click Options.
5. Click Format.
6. In the Find Format dialog box, specify the format for which you want to search.
7. Click OK.Note: You can also define the format you want to find by clicking Choose Format From Cell in the Find Format dialog box, and then clicking a cell with the desired format.