Don't know why this is puzzling me but I want to search for all parts listed within the primeparts array shown below and find them in a table then color the text blue.
So to clarify, using the partial code below, I want to search the range on the Prime Parts sheet for Parts A and Parts B, then color the text Blue.

    function myFunction() 

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('Prime Parts');
  var rows = sheet.getRange('A2:I53');
  var primeParts = ["Part A","Part B"];


  • 1
    Can you provide an example or some sample data to clarify what's the behavior you expect ? – pjmg Aug 7 at 15:53