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"];



closed as unclear what you're asking by Rubén, serenesat, jonsca Aug 8 at 22:50

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

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