Excel for Mac - Find and Replace - No Formatting Option
"Find-and-replace with formatting in Excel for Mac (for example, change the text color or highlight certain words throughout a lengthy document). What I have found, however, is that apparently Excel for Mac doesn't provide this option. How is this possible? It's such a basic, fundamental function. The PC version of Excel lets you do this (of course)."
Taken from https://answers.microsoft.com/en-us/msoffice/forum/msofficeexcel-msomac-mso_o365b/excel-for-mac-find-and-replace-no-formatting/9fbc90df-e0e8-4520-a04c-fcad5abd1cc1