issue with text formatting using replace function

[kuehls]

I what to use the replace function to highlight specific terms that appear in various cells of my spreadsheet to make it easier for others to find the relevant information in my spreadsheet.

I open the tool to input the find term

I input the replace term (same word) but change the font format to a new color.

I then select replace all and the font color of the entire cell is changed. I only want it to change the specific term.

I have unlocked cells and checked permission on the xlsx workbook. It originally was an export file from a patent database but I saved as xlsx.

I built a demo file with typed in text and got the same result. Is excel capable to do what I want?

 

[Pecoflyer]

Hello

You will definitely need VBA to do this. I moved your thread to the VBA forum

 

[kuehls]

Hello

You will definitely need VBA to do this. I moved your thread to the VBA forum

thanks, VBA will be a little beyond what I was hoping to invest timewise.

 

[NoS]

VBA will be a little beyond what I was hoping to invest timewise.

If that means you've abandoned this, so be it.
If not, how about posting the demo file you built and see what others can do with it.