Function applyMcDonaldsStyle

Formatting.js:51–91

()

}

  function applyMcDonaldsStyle() {
  // Get the active spreadsheet and sheet
  const spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = spreadsheet.getActiveSheet();

  // Get the last row and column
  const lastRow = sheet.getLastRow();
  const lastColumn = sheet.getLastColumn();

  // Define the header range
  const headerRange = sheet.getRange(1, 1, 1, lastColumn);

  // Apply header formatting
  headerRange.setBackground('#FFC72C'); // McDonald's Yellow
  headerRange.setFontWeight('bold');
  headerRange.setFontFamily('Arial'); // A commonly available bold font
  headerRange.setFontColor('#D9001B'); // McDonald's Red
  headerRange.setHorizontalAlignment('center');

  // Apply red alternating row background for data
  for (let i = 2; i <= lastRow; i++) {
    const rowRange = sheet.getRange(i, 1, 1, lastColumn);
    if (i % 2 === 0) { // Even rows
      rowRange.setBackground('#FFE0B2'); // Lighter Yellow
    } else { // Odd rows
      rowRange.setBackground('#FFF3E0'); // Very light orange/beige
    }
    rowRange.setFontFamily('Arial');
    rowRange.setFontColor('#000000'); // Black text
  }

   // Example of formatting a specific column (e.g., Sales column)
  const salesColumnIndex = 5; // Assuming "Sales" is the 3rd column
  const salesColumnRange = sheet.getRange(2, salesColumnIndex, lastRow - 1, 1);
  salesColumnRange.setNumberFormat('$#,##0'); // Currency format

  // Auto-resize columns
  sheet.autoResizeColumns(1, lastColumn);

  Logger.log('McDonald\'s style formatting applied!');
}

function applyCocaColaStyle() {
  // Get the active spreadsheet and sheet