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