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

Summarize Data With Dynamic Subtotals What does it do? It returns a Subtotal in a list or database Formula breakdown: =SUBTOTAL(function_num, ref1) What it means: =SUBTOTAL(function number 1-11 includes manually-hidden rows & 101-111 excludes them, your list or range of data) ***Go to the bottom...
Add Hyphens To Serial Numbers Using Excel Flash Fi...   Flash Fill in Excel is a new feature that was introduced in Excel 2013. Flash Fill allows you to combine, extract, move & transform data that belongs in one column, into a new column. One of the cool uses of Flash Fill is formatting numbers.  In our example be...
Running Total In % with an Excel Pivot Table A Running Total In is the accumulation of values over a certain period, like days, month or years.  It is sometimes referred to as the Year to Date analysis. A Running Total In takes one period's values, then adds a second period, then a third period...and so on, to give the a...
Autosum an Array of Data in Excel When you have an array of data in Excel with Totals at the bottom and to the right of the data, you can quickly fill in the Totals with the Autosum button. STEP 1: Highlight your data including the "Totals" row and column; STEP 2: Click the Autosum button (under the Home or...