GhostPixels

Google Sheets unusual Kanji color changer

Nov 7th, 2017
201
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function changeColor() {
  2.   var ss = SpreadsheetApp.getActiveSpreadsheet();
  3.   ss.getSheets().forEach(function(sheet) {
  4.     var rows = sheet.getMaxRows();
  5.     var columns = sheet.getMaxColumns();
  6.     var values = sheet.getRange(2, columns, rows).getValues();
  7.     for (i = 0; i < rows - 2; i++) {
  8.       var regex = /^\D+\d\.\D+Usually written using kana alone.*/g;
  9.       if(regex.test(values[i][0])) {
  10.         sheet.getRange(i + 2, 1).setBackgroundRGB(235, 235, 235);
  11.       }
  12.     }
  13.   });  
  14. }
Add Comment
Please, Sign In to add comment