Let's face it—if you're automating your data workflow with formulas, you shouldn’t be manually rewriting text just to change ...

Also Read: How to change the color of the Excel worksheet Tab. If you want, you may preview the text occurrences one by one and replace the forecolor using the Find Next and Replace options.