function myFormat() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var res = sheet.getActiveRangeList().getRanges().map(range => {
    const startRow = range.getRow();
    const endRow = startRow + range.getNumRows() - 1;
    const startColumn = range.getColumn();
    const endColumn = startColumn + range.getNumColumns() - 1;
    const temp = []
    for (var r = startRow; r <= endRow; r++) {
      for (var c = startColumn; c <= endColumn; c++) {
        temp.push(sheet.getRange(r, c));
      }
    }
    return temp;
  });
  var patern = /([0-9,]+)\s+кв\.м\./;
  for (i = 0; i < res.length; i++) {
    for (j = 0; j < res[i].length; j++) {
      var cel = res[i][j]
      var s = cel.getValue()
      if (s) {
        var p = s.match(patern);
        if (p) {
          var sl = p[0]
          var pz = p.index
          var pz2 = p.index + p[0].length
          cel.setRichTextValue(SpreadsheetApp.newRichTextValue()
            .setText(s)
            .setTextStyle(pz, pz2, SpreadsheetApp.newTextStyle()
              .setForegroundColor('#9900ff')
              .setBold(true)
              .build())
            .build());
        }
      }
    }
  }
}

function myFormat() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var res = sheet.getActiveRangeList().getRanges().map(range => {
    const startRow = range.getRow();
    const endRow = startRow + range.getNumRows() - 1;
    const startColumn = range.getColumn();
    const endColumn = startColumn + range.getNumColumns() - 1;
    const temp = []
    for (var r = startRow; r <= endRow; r++) {
      for (var c = startColumn; c <= endColumn; c++) {
        temp.push(sheet.getRange(r, c));
      }
    }
    return temp;
  });
  for (i = 0; i < res.length; i++) {
    for (j = 0; j < res[i].length; j++) {
      var cel = res[i][j]
      var s = cel.getValue()
      if (s) {
          var pz = 45
          var pz2 = 50
          cel.setRichTextValue(SpreadsheetApp.newRichTextValue()
            .setText(s)
            .setTextStyle(pz, pz2, SpreadsheetApp.newTextStyle()
              .setForegroundColor('#9900ff')
              .setBold(true)
              .build())
            .build());
      
      }
    }
  }
}