Saturday, December 4, 2021

Blinking sheet by color

 function onEdit(e)

{

var ss = SpreadsheetApp.getActiveSpreadsheet();

var mysheet = ss.getSheetByName("Working Sheet Glue dept.");


if( activeCell == "i4" )

var activeCell = ss.getActiveCell().getA1Notation();


{

for(var i=0;i<50;i++)

{

if( i%2 == 0 )

mysheet.getRange("i4").setBackground("GREEN");

else

mysheet.getRange("i4").setBackground("WHITE");


SpreadsheetApp.flush();

Utilities.sleep(500);

}

}

}


Details  aakash verma

Connection data

https://docs.google.com/spreadsheets/d/1BVxe7WHRyKnJzvosExEGk8U2aCUcxPn9k7Hx4yv23hY/edit?usp=sharing

Master

https://docs.google.com/spreadsheets/d/1lFw6s1xhARnOam0f1G3axnIgv-phIDGKGftpIRuZ5WM/edit?usp=sharing

Stock

https://docs.google.com/spreadsheets/d/1mdhU9uAbmci2KjdMtvYckstVc4gIWu5uDvtjSvG-YMs/edit?usp=sharing


No comments:

Post a Comment

THANKS FOR YOUR SUPPORT

Data copy paste on two another sheet with add row in google sheet by script

 function copyDataWithinWorkbook() {   var sourceSheetName = "Dashbord"; // Replace with the name of the source sheet   var target...