How To Change The Font Color On Certain Text In Excel?

Date:2022-4-12 Author:Sandra

Have you ever tried to change the font color on certain text in one cell in Excel?  You maybe think of this as very simple. You can test in a worksheet now. It’s would not be such simple as your thoughts.

Let’s take an example. Change the font color of the word “your” to red color.

How To Change The Font Color On Certain Text In Excel?
How To Change The Font Color On Certain Text In Excel?
How To Change The Font Color On Certain Text In Excel?

Oh, it’s failed. All the texts in this cell are in red now.

 But if these texts are in different cells. The replacement can be down successfully.

How To Change The Font Color On Certain Text In Excel?
How To Change The Font Color On Certain Text In Excel?

So the right and easy way is solved in a Word document.

Copy and paste this paragraph into a word document.

How To Change The Font Color On Certain Text In Excel?

Then press Ctrl + H to quickly open the Find and Replace window.

How To Change The Font Color On Certain Text In Excel?

Change the font color into Red.

How To Change The Font Color On Certain Text In Excel?

Then hit Replace All.

How To Change The Font Color On Certain Text In Excel?
How To Change The Font Color On Certain Text In Excel?

Now copy and paste this paragraph into the Excel worksheet.

How To Change The Font Color On Certain Text In Excel?

That’s easy, right? Hope this tutorial can be helpful to you.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *