I have created a handy highlighting tool using Google Sheets and Google Apps Script. The specification of this tool is very simple.
- The user pastes a message into the certain cell (A2).
- The tool checks if the message contains some words which listed in another dedicated sheet(Spam Word List).
- The tool highlights (bold and color red) the found words in the message.
Here is a nice post demonstrating how you can use Google Apps Script to highlight keywords within a Google Sheets cell. The solution uses
SpreadsheetApp.newTextStyle() to create a custom style which is then applied to part of the cell text.
Source: [Google Sheets] Word Highlighter