# Apply Red Background to "Unknown - Call" Cells

## Cells Needing Red Background in Column G:

1. **Row 2:** Aotearoa Park Developments - "Unknown - Call"
2. **Row 21:** Fresh Fruit Company of New Zealand - "Unknown - Call"

## How to Apply (Manual):

1. Open the Google Sheet: https://docs.google.com/spreadsheets/d/1uVd-xZFF4TEQGqtvw9z6W8fffeaifPCoLsek83GmEoQ/edit
2. Go to "New Zealand" sheet
3. Select cell G2
4. Click paint bucket icon or Format > Fill color
5. Choose light red (#FFC7CE or similar)
6. Repeat for cell G21

## Automated Script (if needed):

You can also apply via Apps Script in Google Sheets:

```javascript
function formatUnknownCells() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = ss.getSheetByName('New Zealand');
  const range = sheet.getRange('G:G');
  const values = range.getValues();
  
  for (let i = 0; i < values.length; i++) {
    if (values[i][0] && values[i][0].toString().includes('Unknown - Call')) {
      sheet.getRange(i + 1, 7).setBackground('#FFC7CE');
    }
  }
}
```

To use:
1. Open Google Sheet
2. Extensions > Apps Script
3. Paste code above
4. Run `formatUnknownCells`