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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Find Errors with Go to Special Constants Say you have a data set and want to make sure that each column contains what it is supposed to. For example, say you have a column which contains Dates and you want to check that there are no cells which contain Text. You can easily check this by highlighting that column an...
Dynamic Data List using Excel Tables Excel Tables have many great features to them and one of them is their ability to create a dynamic drop down list. A dynamic drop down list expands as the Excel Table expands when new data gets added to it. This is great when you want to have users select from a predefined ...
Custom Date Formats in Excel Custom date formats in Excel allow you to display only certain parts of the date. Say you had a date of 18/02/1979, which coincides to be my birthday 🙂 You can use the Format Cells dialogue box to show only the number 18, the day that corresponds to that date (Sunday), the...
Data Bars, Color Scales & Icon Sets Conditional Formatting has improved in Excel 2010 with the introduction of Data Bars, Color Scales & Icon Sets. Data Bars: Includes graphic bars in a cell, proportional to the cell’s value - Good for Financial Analysis Color Scales: Includes a background color, proporti...