dnalob

## macro.gs
// 3. Format Text Example
function FormatText() {
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getActiveRangeList().setFontWeight('bold')
  .setFontStyle('italic')
  .setFontColor('#ff0000')
  .setFontSize(18)
  .setFontFamily('Montserrat');
};

## text-to-columns.js
function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var menuEntries = [];
  menuEntries.push({ name:"Text to columns", functionName:"textToColumns" });
  menuEntries.push({ name:"Text to columns (custom separator)", functionName:"textToColumnsCustom" });
  menuEntries.push(null);
  menuEntries.push({ name:"Columns to Text", functionName:"columnsToText" });
  menuEntries.push({ name:"Columns to Text (custom separator)", functionName:"columnsToTextCustom" });
  ss.addMenu("Advanced", menuEntries);
}

## find-cell-value-and-delete-row.js
function deleteRows() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var rows = sheet.getDataRange();
  var numRows = rows.getNumRows();
  var values = rows.getValues();

  var rowsDeleted = 0;
  for (var i = 0; i <= numRows - 1; i++) {
    var row = values[i];
    if (row[0] == 'delete' || row[0] == '') { // This searches all cells in columns A (change to row[1] for columns B and so on) and deletes row if cell is empty or has value 'delete'.
	// 3. Format Text Example
	function FormatText() {
	var spreadsheet = SpreadsheetApp.getActive();
	spreadsheet.getActiveRangeList().setFontWeight('bold')
	.setFontStyle('italic')
	.setFontColor('#ff0000')
	.setFontSize(18)
	.setFontFamily('Montserrat');
	};
	function onOpen() {
	var ss = SpreadsheetApp.getActiveSpreadsheet();
	var menuEntries = [];
	menuEntries.push({ name:"Text to columns", functionName:"textToColumns" });
	menuEntries.push({ name:"Text to columns (custom separator)", functionName:"textToColumnsCustom" });
	menuEntries.push(null);
	menuEntries.push({ name:"Columns to Text", functionName:"columnsToText" });
	menuEntries.push({ name:"Columns to Text (custom separator)", functionName:"columnsToTextCustom" });
	ss.addMenu("Advanced", menuEntries);
	}