NotSooFriendly94

Untitled

Jan 7th, 2024
42
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. for(var i = 0; i < 100; i++){
  2. var row1 = range('A' + (i + 3));
  3. var row1Dest = range('A' + (i + 4));
  4. var row2 = range('B' + (i + 2));
  5. var row2Dest = range('B' + (i + 3));
  6. var row3 = range('C' + (i + 1));
  7. var row3Dest = range('C' + (i + 2));
  8. var c = 40;
  9.  
  10. row1.setValue('');
  11. row1.setBackground('white');
  12. row2.setValue('');
  13. row2.setBackground('white');
  14. row3.setValue('');
  15. row3.setBackground('white');
  16. sleep(100);
  17.  
  18. row1Dest.setValue(1);
  19. row2Dest.setValue(2);
  20. row3Dest.setValue(3);
  21.  
  22. if (i - 3 < 40) {
  23. row1Dest.setBackground(row1Colours[i]);
  24. row2Dest.setBackground(row2Colours[i]);
  25. row3Dest.setBackground(row3Colours[i]);
  26. } else if (i - 3 >= 40) {
  27. row1Dest.setBackground(row1Colours[c]);
  28. row2Dest.setBackground(row2Colours[c]);
  29. row3Dest.setBackground(row3Colours[c]);
  30. c--;
  31. }
  32.  
  33. SpreadsheetApp.flush();
  34. sleep(100);
  35. }
  36. }
Advertisement
Add Comment
Please, Sign In to add comment