---
title: "[Google Sheets] Word Highlighter (made using Google Apps Script)"
author: "Martin Hawksey"
date: 2022-03-01T21:53:55+00:00
modified: 2022-03-01T21:54:04+00:00
canonical_url: https://pulse.appsscript.info/p/2022/03/google-sheets-word-highlighter-made-using-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2022/03/google-sheets-word-highlighter-made-using-google-apps-script.md
categories:
  - "Beginner"
  - "Sheets"
  - "Solutions"
  - "V8"
tags:
  - "@inclu_cat"
  - "inclu-cat.net"
featured_image: https://pulse.appsscript.info/files/2022/03/image-5.png
description: "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.  "
---

# [Google Sheets] Word Highlighter (made using Google Apps Script)

![[Google Sheets] Word Highlighter (made using Google Apps Script)](https://pulse.appsscript.info/files/2022/03/image-5.png)

> [https://inclucat.wordpress.com/2022/02/28/google-sheets-word-highlighter/](https://inclucat.wordpress.com/2022/02/28/google-sheets-word-highlighter/)
> 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()**](https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app#newtextstyle)` to create a custom style which is then applied to part of the cell text.

Source: *[[Google Sheets] Word Highlighter*](https://inclucat.wordpress.com/2022/02/28/google-sheets-word-highlighter/)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2022/03/google-sheets-word-highlighter-made-using-google-apps-script/](https://pulse.appsscript.info/p/2022/03/google-sheets-word-highlighter-made-using-google-apps-script/)*