Guest User

Untitled

a guest
May 25th, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. function ifBold(cell, val1, val2) {
  2. if(cell.getFontWeight() == 'bold')
  3. return val1;
  4. return val2;
  5. }
  6.  
  7. function ifBold(a1Notation, val1, val2) {
  8. var cell = SpreadsheetApp.getActiveSpreadsheet().getRange(a1Notation);
  9.  
  10. if(cell.getFontWeight() == 'bold')
  11. return val1;
  12. return val2;
  13. }
  14.  
  15. function ifBold(row, column, val1, val2) {
  16. var range = SpreadsheetApp.getActiveSpreadsheet().getDataRange().getCell(row, column);
  17.  
  18. if(range.getFontWeight() == 'bold')
  19. return val1;
  20. return val2;
  21. }
  22.  
  23. function ifBold() {
  24. var sheet = SpreadsheetApp.getActive().getSheetByName('Bold');
  25. var cells = sheet.getRange('A2:A');
  26. for (var i=1; i <= cells.getNumRows(); i++) {
  27. var isBold = false;
  28. if(cells.getCell(i, 1).getFontWeight() == 'bold')
  29. isBold = true;
  30. sheet.getRange(i+1, 2).setValue(isBold);
  31. }
  32. }
  33.  
  34. function ifBold() {
  35. var sheet = SpreadsheetApp.getActive().getSheetByName('Bold');
  36. var cells = sheet.getRange('A2:A');
  37. for (var i=1; i <= cells.getNumRows(); i++) {
  38. var isBold = false;
  39. if(cells.getCell(i, 1).getFontWeight() == 'bold')
  40. isBold = true;
  41. sheet.getRange(i+1, 2).setValue(isBold);
  42. }
  43. }
Add Comment
Please, Sign In to add comment