Google Apps Script Generator — illustrative example

INPUT
Google Apps Script, bound to a spreadsheet. On sheet Intake, highlight blank cells in A2:B5 light red and reset nonblank cells to white. This explicit range contains required input cells only. Manual execution.

RESULT
function markMissingRequiredCells() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Intake');
  if (!sheet) throw new Error('Missing sheet: Intake');
  const range = sheet.getRange('A2:B5');
  const colors = range.getDisplayValues().map(row =>
    row.map(value => value.trim() === '' ? '#fce8e6' : '#ffffff')
  );
  range.setBackgrounds(colors);
}

Only backgrounds in Intake!A2:B5 change; existing colors there are replaced. Test on a copy and review spreadsheet authorization. This example has not been executed in Apps Script.

REVIEW
An Apps Script draft needs clear scope and permissions. Prefer a user-triggered operation for an initial version and avoid unnecessary access to other services.

This is a teaching example, not a live execution record.