Skip to content

Instantly share code, notes, and snippets.

@reggi
Created December 16, 2020 17:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save reggi/8c260a9df3f58ccb11820f58fc4e4bad to your computer and use it in GitHub Desktop.
Save reggi/8c260a9df3f58ccb11820f58fc4e4bad to your computer and use it in GitHub Desktop.
Google Sheets Border Script
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