Function applyCocaColaStyle

Formatting.js:93–133

()

}

function applyCocaColaStyle() {
  // 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 - Coca-Cola Red and White
  headerRange.setBackground('#CC0000'); // Coca-Cola Red (approximate)
  headerRange.setFontWeight('bold');
  headerRange.setFontFamily('Arial'); // A clean, readable font
  headerRange.setFontColor('white');
  headerRange.setHorizontalAlignment('center');

  // Apply alternating row backgrounds - White and Very Light Gray
  for (let i = 2; i <= lastRow; i++) {
    const rowRange = sheet.getRange(i, 1, 1, lastColumn);
    if (i % 2 === 0) { // Even rows
      rowRange.setBackground('white');
    } else { // Odd rows
      rowRange.setBackground('#f0f0f0'); // Very light gray
    }
    rowRange.setFontFamily('Arial');
    rowRange.setFontColor('black');
  }

   // 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.00'); // Currency format

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

  Logger.log('Coca-Cola style formatting applied!');
}

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