How to Find and Replace Text Color in Excel

On this put up, we are going to present you how to discover and change Text Color in Excel. Text coloration, also referred to as the forecolor, is the colour in which the textual content is displayed in Microsoft Excel. By default, that is set to Black. You’ll be able to manually change the textual content coloration for a part of the textual content or your entire textual content in your Excel information utilizing the Font Color choice. In some circumstances, the information might comprise a number of occurrences of the identical textual content whose coloration wants to be modified. In case your Excel file is kind of giant, altering the forecolor manually might be tiresome and time-consuming. On this put up, we are going to present you the way to use the ‘Find and Replace’ characteristic to change textual content coloration in Excel.

How to Find and Replace Text Color in Excel

Find and Replace is a helpful characteristic in the Workplace suite applications which permits changing an present textual content with a brand new textual content. Nevertheless, it can be used to discover and change the colour of the textual content. Chances are you’ll use this characteristic to change the forecolor one after the other for every prevalence of the textual content, or use Replace All to replace the forecolor in one go. Allow us to perceive this with the assistance of an instance.

Suppose now we have a worksheet whereby now we have a desk that lists down the put up titles and the writer names for posts printed on TheWindowsClub on a specific day (see the above picture). Now let’s say we would like to change the textual content coloration for the identify of a specific writer ‘Guru Mandadi’, who has contributed essentially the most on that day.

We might do that manually as follows:

1. Choose the primary prevalence of ‘Guru Mandadi’ by inserting the cursor in cell C1.
2. Press and maintain the Ctrl button on the keyboard and click on on all different occurrences of ‘Guru Mandadi’ one after the other.
3. Click on on the Font Color dropdown throughout the Font toolbar on the high.
4. Click on on the colour that ought to change the present forecolor.

Use Find and Replace to change the textual content coloration in Excel

Whereas this may occasionally appear easy and straightforward, manually altering the forecolor is probably not the best method for bigger databases the place the textual content might seem a whole bunch or hundreds of occasions at totally different areas in the spreadsheet. In such situations, it’s possible you’ll use the Find and Replace characteristic. For the above instance, this works as follows:

1. Choose the cell vary the place the textual content coloration wants to get replaced. If it’s the complete spreadsheet, don’t choose something.
2. Click on on the Find and Choose dropdown throughout the Enhancing toolbar in the top-right nook.
3. Click on on the Replace choice.
4. Within the Find and Replace dialogue field, click on on the Choices button. This may broaden the dialogue field and present superior choices.
5. Sort the textual content in the Find what discipline. For the above instance, now we have entered ‘Guru Mandadi’ in this discipline.
6. Click on on the Format dropdown subsequent to the Replace with discipline.
7. Choose the Format choice.
8. Within the Replace Format dialogue field, click on on the Color dropdown and choose the colour that ought to change the present coloration of the desired textual content.
9. Click on on the OK button.
10. Click on on the Replace All button in the Find and Replace dialogue field to apply the brand new coloration to the textual content.

Excel will warn you with the variety of replacements made in your entire sheet or the chosen cell vary.

Observe: You might also use different formatting choices accessible throughout the Replace Format dialogue field to change the looks of your textual content, akin to its font type, measurement, and so on.

Additionally Learn: How to change the coloration of the Excel worksheet Tab.

In order for you, it’s possible you’ll preview the textual content occurrences one after the other and change the forecolor utilizing the Find Subsequent and Replace choices. Right here’s how:

• Comply with steps 1-9 as described above.
• Within the Find and Replace dialogue field, click on on the Find Subsequent button.
• Mouse focus will seem on the primary prevalence of the desired textual content.
• To alter the forecolor, click on on the Replace choice. Else, don’t click on something.
• Once more, click on on the Find Subsequent button.
• Mouse focus will seem on the subsequent prevalence of the desired textual content.
• Click on on Replace to change the textual content coloration.
• Repeat this course of till you’ve made as many textual content coloration replacements as you need.

This winds up with how to discover and change textual content coloration in Excel.

How do I discover and spotlight textual content in Excel?

Press Ctrl+F to open the Find and Replace Dialogue field. Change to the Replace tab. Click on on the Choices button. Sort the specified textual content in the Find what discipline. Choose the Format choice from the Format menu subsequent to the Replace with discipline. Change to the Fill tab in the Replace Format dialogue field. Choose a coloration from the Background Color palette and click on on OK. Click on on the Replace All button to spotlight all of the occurrences of the desired textual content.

Learn Subsequent: Change cell background coloration in Excel with VBA Editor.