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.
STEP1: Open Replace Option
Firstly, follow this:
Go to Home > Find & Select
Now, Select Options.
Then select Format
Here I will set the format that I want to change in my sheet.
Now you need to select the second Format.
I’m setting the format that I need to see as the final formatting.
There you go with your new Green colour formatting.