graphic2
graphic1

Exam 77-420 Microsoft Excel 2013
2. Create Cells and Ranges
2.1 Insert Data in Cells and Ranges: Find and Replace Data

Home->Editing->Find & Select->Replace

Record the Formatting Options

You can format the text at the same time that you replace it. Here are the steps.

 

3. Try This, Too: Format the Text

The Find and Replace window is open.
Click on Options.

What Do You See? The Format... button should be available to the right.

OK, Do This: Format the Text
Go to right of the text in Replace with.
Click on Format...

The Replace Format options will open.
Go to the Font tab.
Change the Font: Arial.
Change the Size: 10.
Change the Color to orange.
Click OK to return to the Find and Replace window.

Finally, Do This: Run the Action
Click Replace All.
Click OK when the replacements are done.
Close the Find and Replace window.

Keep going. The Macro is still recording...