Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function ifBold(cell, val1, val2) {
- if(cell.getFontWeight() == 'bold')
- return val1;
- return val2;
- }
- function ifBold(a1Notation, val1, val2) {
- var cell = SpreadsheetApp.getActiveSpreadsheet().getRange(a1Notation);
- if(cell.getFontWeight() == 'bold')
- return val1;
- return val2;
- }
- function ifBold(row, column, val1, val2) {
- var range = SpreadsheetApp.getActiveSpreadsheet().getDataRange().getCell(row, column);
- if(range.getFontWeight() == 'bold')
- return val1;
- return val2;
- }
- function ifBold() {
- var sheet = SpreadsheetApp.getActive().getSheetByName('Bold');
- var cells = sheet.getRange('A2:A');
- for (var i=1; i <= cells.getNumRows(); i++) {
- var isBold = false;
- if(cells.getCell(i, 1).getFontWeight() == 'bold')
- isBold = true;
- sheet.getRange(i+1, 2).setValue(isBold);
- }
- }
- function ifBold() {
- var sheet = SpreadsheetApp.getActive().getSheetByName('Bold');
- var cells = sheet.getRange('A2:A');
- for (var i=1; i <= cells.getNumRows(); i++) {
- var isBold = false;
- if(cells.getCell(i, 1).getFontWeight() == 'bold')
- isBold = true;
- sheet.getRange(i+1, 2).setValue(isBold);
- }
- }
Add Comment
Please, Sign In to add comment