Za google sheets u extensions pa apps script
unknown
plain_text
a year ago
935 B
12
Indexable
function onOpen() { var ui = SpreadsheetApp.getUi(); ui.createMenu('Custom Menu') .addItem('Add Checkboxes', 'addCheckboxes') .addToUi(); } function addCheckboxes() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var range = sheet.getRange(1, sheet.getLastColumn() + 1, sheet.getLastRow()); range.insertCheckboxes(); // Apply conditional formatting var rule = SpreadsheetApp.newConditionalFormatRule() .whenFormulaSatisfied('=$' + getColLetter(range.getColumn()) + '1=TRUE') .setBackground('#00FF00') // Green color .setRanges([range]) .build(); var rules = sheet.getConditionalFormatRules(); rules.push(rule); sheet.setConditionalFormatRules(rules); } function getColLetter(col) { var letter = ''; while (col > 0) { var temp = (col - 1) % 26; letter = String.fromCharCode(temp + 65) + letter; col = (col - temp - 1) / 26; } return letter; }
Editor is loading...
Leave a Comment