Can Excel 2016 find and replace a word’s (character string) font color?
I need the capability to search a spreadsheet for a word and change that word’s font color. For example, find all instances of the word “ANALYZE” and change the font color to BLUE (0000FF). Similarly, find all instances of the word “DESIGN” and change its font color to GREEN (009900), and so on.
I’m doing it manually now. Would like to run a macro (?) that does it. It would save me 15 minutes of keyboarding time, 10 times a week.