Imagine this, you have a table full of bold text.  The bold text could also be all over your worksheet in random cells.

Then you decide that the bold text does not suit your expected design and prefer red colored text instead.

What would you do?

Changing all of the formatting one by one would be a big pain!!!

Thankfully, Excel allows you to replace formatting with another formatting!

This is our initial Table:

Replace Excel Formatting with Another Formatting

DOWNLOAD EXCEL WORKBOOK

STEP 1: Go to Home > Find  & Select

Replace Excel Formatting with Another Formatting

Then select the Replace option.

Replace Excel Formatting with Another Formatting

 

STEP 2: Select Options.

Replace Excel Formatting with Another Formatting

 

STEP 3: Select Format.  We will set the format that we want to change.

Replace Excel Formatting with Another Formatting

Make sure Bold is selected. Click OK.

Replace Excel Formatting with Another Formatting

 

STEP 4: Select the second Format.  We will set the format that we want to be the final formatting.

Replace Excel Formatting with Another Formatting

 

Make sure the color Red is selected. Click OK.

Replace Excel Formatting with Another Formatting

 

STEP 5: Click Replace All and see the magic happen!

Replace Excel Formatting with Another Formatting

 

The formatting is now replaced with the color Red!

Replace Formatting

Replace Excel Formatting with Another Formatting

Replace Formatting

Helpful Resource:

728x90

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Clear a #REF! Error in Excel When your Excel workbook has formulas that are linked to other workbooks/cells that have been deleted, you will get a #REF! error.This means that the formula refers to a cell that isn’t valid.To get rid of this error message we have to select the cell(s) with this error, ...
Drop Down Menu In Your Excel Table Apart from creating a simple Drop Down Menu/List or Data Validation List, you can expand this concept to include it in your Excel Table or Database.Watch how to insert a Data Validation ListThat way you don't have to do repetitive tasks like entering the same customer ov...
Change the Axis Units in an Excel Chart Whenever you create a chart in Excel, it gives you the default vertical Axis based on the values that are in your data set.If you have large numbers in your data, like tens or hundreds of millions of dollars, then the vertical axes will take up lots of real estate space in yo...
Show The Percent of Difference From Previous Years...  I am sure that your boss has asked you to come up with a Year on Year variance report at some stage.  There are a couple of ways to get him/her an answer.One is using Formulas, but that will take time to set up and you are exposed to errors!The other method is t...