I want help with Excel VBA code
I need a code which can replace specific word, for example "YES", in a single cell with red color of that same word, here "YES" with a red color. In addition, if this word repeats multiple times in a single cell, then it should replace all those words.
For example,
if Range("A1") has value "YES I am ok, How about you? YES, I am ok too."
Then the replacement should be "YES I am ok, How about you? YES, I am ok too."
Bookmarks