Thanks for a quick a reply. But what if I want to change the search text with different text? I also noticed that if there are 2 or 3 search words in the same cell, only the first occurrence was change to red fonts. would it be possible to change all of them?