Apps Script – Search Active Sheet to find matching text results of cells

Use of the createTextFinder method to search a sheet object and return back the matching results.  To get the first value use the method findNext() in the results which is an iterator.  To convert all the matching results into an array object use the findAll() method.  This will return an array format object that contains the cells as items in the array.   From here you can use array methods to interact with the items in the found results.

function searchIt() {

 const sheet = SpreadsheetApp.getActiveSheet();

 const findString = ‘dog’;

 const textFinder = sheet.createTextFinder(findString);

 Logger.log(textFinder);

 const items = textFinder.findAll();

 Logger.log(items);

 //const cell = textFinder.findNext();

 items.forEach(cell=>{

   const row = cell.getRow();

   const col = cell.getColumn();

   cell.setBackground(‘yellow’);

   Logger.log(`Found at Row:${row} Col:${col}`);

 })

}