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

Text To Columns: Dates Whenever you download data from an external ERP system like Oracle, SAP, etc, you can have data that is not formatted the way you and Excel likes.Sometimes "Date" values are downloaded as "Text", so you cannot sort in the periodic date format.No worries!  Text to Columns ...
Quick Access Toolbar The Quick Access Toolbar (QAT) is located at the top left hand corner of the ribbon and has the most commonly used commands, like the Save, Undo and Redo.  The QAT is unique to each user´s workbook settings.You can move the QAT below or above the ribbon by right clicking on t...
Row Differences If you have two rows that you want to compare, for example, sale amount versus amount paid, you can easily filter the differences between these two columns by going in to the Find & Select > Go To Special > Row Differences.Once the cells have been identified, you ca...
Fix Excel Hyperlinks to a Named Range Hyperlinks in Excel must be one of the funkiest features that I love playing around with!They allow you to create interactive buttons within Excel (without the need to create a Macro) and you can make them take you to any cell or range within your Excel worksheet.One shor...