Replace Excel Formatting with Another Formatting

Have you ever faced that you have table full of bold text, then you find out that the bold text does not suit your expected design and now you need to format the Green colour text?

But changing one by one all formatting would be time wasting. Thanks to Excel that will allow you to replace formatting with another formatting.

Previously In AnalysisHow to Distribute and Align Shapes in Excel?

Replace Excel Formatting with Another Formatting

STEP1: Open Replace Option

Firstly, follow this: 

Go to Home > Find & Select

Replace Excel Formatting with Another Formatting
Then you need to select the Replace option.

Now, Select Options.

Replace Excel Formatting with Another Formatting

STEP2: Formatting

Then select Format

Here I will set the format that I want to change in my sheet.

Replace Excel Formatting with Another Formatting
Ensure that Bold is already selected and then Click OK.

Now you need to select the second Format

I’m setting the format that I need to see as the final formatting.

Replace Excel Formatting with Another Formatting
Ensure to select the Green colour and then Click OK.

There you go with your new Green colour formatting.

Replace Excel Formatting with Another Formatting