title: Is there a way to make part of a cell bold?
body: <p>I have several rows in google sheets that take sentences from several tabs then return them in another tab. Note that those cells contain formulas. I wrote a script and it works perfectly but I don't know what to add to make certain words <strong>BOLD</strong>.</p>
  <pre><code>     function onOpen() {
    var ui = SpreadsheetApp.getUi();
    ui.createMenu('Hide')
        .addItem('Hide All Empty Rows', 'clear')
        .addToUi();
  }
  
  function clear() {
      const sheet = SpreadsheetApp.getActive().getSheetByName('NY Quote with Rebate');
      const sheetRANGE = sheet.getDataRange();
      const rangeVals = sheetRANGE.getValues();
  
      for (let i = rangeVals.length - 1; i &gt;= 0; i--) {
          if (i &gt; 8) {
              const $row = rangeVals[i];
              let data = 0;
              for (const [key, value] of Object.entries($row)) {
                  if (value !== '') {
                      data = 1;
                  }
              }
              if (data === 0) {
                  sheet.hideRows(i + 1);
              }
          }
      }
  
      const maxRows = sheet.getMaxRows();
      const lastRow = sheet.getLastRow();
      if (maxRows !== lastRow) {
          if (lastRow &gt; 9) {
              sheet.hideRows(lastRow + 1, maxRows - lastRow);
          } else {
              sheet.hideRows(9, maxRows - 9);
          }
      }
  }
  </code></pre>