# Highlight words in column based on master list of words

**URL:** <https://connect.superhuman.com/t/highlight-words-in-column-based-on-master-list-of-words/17458>\
**Category:** Ask the Community\
**Created:** [July 28, 2020, 1:09am UTC](https://connect.superhuman.com/t/highlight-words-in-column-based-on-master-list-of-words/17458 "2020-07-28T01:09:17Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![Paul\_Danyliuk](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/paul_danyliuk/32/27228_2.png) [@Paul\_Danyliuk](https://connect.superhuman.com/u/Paul_Danyliuk)\
**Post date:** [July 29, 2020, 8:07pm UTC](https://connect.superhuman.com/t/highlight-words-in-column-based-on-master-list-of-words/17458/5 "2020-07-29T20:07:12Z")

</div>

Here’s a solution that can match phrases. It’s a multi-step one though. Also it should be a more robust one than the one above, since it doesn’t split the text by every word but only wherever necessary to then stitch it back.

https://coda.io/embed/e2ia-uJBGU?viewMode=embed

It uses a hidden `RegexExtract` formula; it supports flags so instead of using `Lower()` elsewhere I just set it up to work as case-insensitive.

---

_[View the full topic](https://connect.superhuman.com/t/highlight-words-in-column-based-on-master-list-of-words/17458)._