You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.

How to Forward Totals From One Spreadsheet to a Total Spreadsheet for Microsoft Excel. Using a formulaic reference to the total on another Excel 2013 sheet creates a dynamic link between the two ...

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.

Also Read: How to change the color of the Excel worksheet Tab. If you want, you may preview the text occurrences one by one and replace the forecolor using the Find Next and Replace options.