Home > database >  How to modify the script below to compare words from column B with the content of Cell C23?
How to modify the script below to compare words from column B with the content of Cell C23?

Time:10-23

How can I modify the Apps Script to read the content of cell C23 and compare it with the list of banned words from the Banned Words Data tab's Col B instead of a hardcoded array in the below example.

If there is a match turn that word red and bold in cell C23 and put the matching words in a cell next to it. enter image description here

  • Related