How to Find and Replace Formatting in Excel
Excel’s Find and Replace features can find and/or replace formatting in addition to text and information. Use the Find and Replace Formatting option when you want to change all instances of a particular formatting choice at once.
Press Ctrl + H to open the Find and Replace dialog box
The Find Format dialog box opens. Here you can select any type of formatting you want to look for in the workbook.
Once the formatting options are set, you’re ready to begin finding and replacing the formatting.