title: Script to make cells in a column of a spreadsheet bold based on value. (Conditional formatting?)
body: <p>I need a script that formats the cells in column A bold, but only the cells that contain the word 'Hello'. Also, a similar script that makes the cells containing 'hello' aligned center and one that also formats underlined. You can't conditionally format bold or align or underline in Google Sheets, so I will need a script.</p>
  
  <p>I think it's something like this but I don't know what the last line would be.</p>
  
  <pre><code>function formatBold() {
  
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var s = ss.getSheetByName('Sheet1');
    var values = s.getDataRange().getValues();
  
    for( var row = values.length -1; row &gt;= 0; --row )
      if (values[row][0] == 'Hello')
  
  };
  </code></pre>
  
  <p>Does anyone know how to complete this script or if there is a better script for the job?</p>