I would like to have Excel search through a workbook, and change the font
color of a string of text wherever it occurs in the workbook. For example if
I'm searching for "widgets", if cell A14 contains " no widgets were sold
this week", I would like the font color of "widgets" to be red. If that
can't be done, I'll settle for the font color of all of cell A14 to be red.
Can it be done without VBA?