Click on the Replace All button in the Find and Replace dialogue box to apply the new color to the text. Excel will alert you with the number of replacements made in the entire sheet or the ...

If you wish to perform a sheet-wide search, do not select multiple cells. Hold the "Ctrl-H" keys to open the "Find and Replace" window. Enter the text you wish to replace in the "Find What" field.