To use Find and Replace with formatting, click the Edit menu from the menu bar and select

Find from the option list. Edit->Find

This will display the Find and Replace dialogue box.

Click the Options button to display the options for formatting.

Open the drop down list under the Format button and click Format.

You will now see the Find Format dialogue box.

From this box you can select a Number format from the category list. You can also select a format option from the tabs at the top of the box. (You can search for alignment, colour, font type, and more) You can even choose a format from a cell by clicking the Choose format From Cell button.

If you click this button, you will see a thick cross mouse pointer with an eye dropper beside it. Click this pointer on a cell with formatting that you want to find, and the

Find and Replace dialogue box will be displayed again.

Make sure that the Replace tab on the dialogue box is selected to show the options for choosing a replacement format.

You can choose a replacement format in an exactly similar way as choosing a format to find.

Once you choose a replacement format, click find next to replace the unwanted format one cell at a time. Click Replace All to perform all of the replacements at once.

There are options available in the list boxes to search worksheets, workbooks, and formulas.

If you display the drop down list by the Format button, There is also an option to choose a replacement format from a cell.