Check if at least 3 cells in a row have a certain background

Vote count:

0

1) I will have at least 4 columns where cells will have different backgrounds 2) I have to check if at least 3 of cells in a row have per say RED background 3) If it is so - output smth in a cell on that row, per say "WARNING"

I'm no js guy, the only thing I got is:

function check() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Canvas');
  if (sheet.getRange("E5").getBackground() == '#ff0e13' && sheet.getRange("F5").getBackground() == '#ff0e13' && sheet.getRange("D5").getBackground() == '#ff0e13') {
    return sheet.getRange('M5').setValue('Warning');
  }
}

This on check only certain cells in a certain row. How can I edit that to work with an array ("to drag it on all rows")?

asked 37 secs ago

Edgard Gomez Sennovskaya

15