Created
December 16, 2020 17:44
-
-
Save reggi/8c260a9df3f58ccb11820f58fc4e4bad to your computer and use it in GitHub Desktop.
Google Sheets Border Script
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function colorAll() { | |
var sheet = SpreadsheetApp.getActiveSheet(); | |
var startRow = 1; | |
var endRow = sheet.getLastRow(); | |
for (var r = startRow; r <= endRow; r++) { | |
colorRow(r); | |
} | |
} | |
function colorRow(r){ | |
var sheet = SpreadsheetApp.getActiveSheet(); | |
var dataRange = sheet.getRange(r, 1, 1, 3); | |
var data = dataRange.getValues(); | |
var row = data[0]; | |
if(row[0] === ""){ | |
// dataRange.setBackgroundRGB(255, 255, 255); | |
}else { | |
dataRange.setBorder(true, true, true, true, true, true, "black", SpreadsheetApp.BorderStyle.DOTTED); | |
} | |
SpreadsheetApp.flush(); | |
} | |
function onEdit(event) | |
{ | |
var r = event.source.getActiveRange().getRowIndex(); | |
if (r >= 2) { | |
colorRow(r); | |
} | |
} | |
function onOpen(){ | |
colorAll(); | |
} | |
function onEdit() { | |
colorAll(); | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment