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 :)