0

I'm looking to get this running but am having issues getting the if statements right. The aim is to have the function check a cell value against another and 'blink' the cell background if true to draw the user's eye to that cell.


function onEdit(e) {
 if (e.range.columnStart !=1 || e.value != "TRUE") return;
 const rData = e.source.getActiveSheet().getRange(e.range.rowStart,1,1,25).getValues()
 
 let status = rData[0][1];
 let name = rData[0][4];
 let calls = rData[0][24];
 if (status == "TRUE" || name == calls){
   var number = 50; // Number of blink
   for (var i = 0; i <= number * 2; i++) {
     if (i % 2 == 0) {
       var color = "white";
     } else {
       var color = "red";
     }
     e.range.setBackground(color);
     SpreadsheetApp.flush();
     Utilities.sleep(1000); // Blink speed (ms)
   }
   e.range.setBackground("white") // Cell color is white after blinks were completed.
 }
 

}

all help appreciated :)

Rubén
  • 29,320
  • 9
  • 61
  • 145

0 Answers0