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 ...

Enter the text you wish to use for replacement in the "Replace With" field. Click "Replace All" to find and replace each instance of the text part located in the selected cells or entire sheet.