Change the format of a word in an excel file

[DavidMunoz]

Hi all,

I have an excel document with multiple cells. All the cells have text (different words) and some of those cells contain the word "YES".

 I want to change the format of those "YES" words (and only those words) to bold but when I use the replace function to change the format of all the ocurrences of the word "YES", Excel changes to bold all the text of te cells that contain the word "YES"

[#2]

@DavidMunoz 

It works with entire cell value, you can't reformat part of the string such way. That's manually by selecting part of the text and applying desired format; or VBA programming.