Google Sheets Conditional Formatting Reset

What the source does

• FilesystemNone observedNo reads or writes in the source
• NetworkNone observedNo outbound calls in the source
• ShellNone observedNo commands run in the source
• DependenciesPinnedNothing floats
• SecretsNone foundNo keys in source

Five audit layers

Gates applied: no behavioural pass.

Audit 0.4.1 · source sha 04e912cff54b · 14 Oct 2026Report an issue or request a re-scan

• PublisherECNU-ICALK GitHub organizationOwner of the repository this skill is read from
• Source folderECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt4_8_GLM4.7/google_sheets_conditional_formatting_resetThe exact folder we audited
• LicenceNot declaredAs the repository states it
• Commit pinned for this verdict04e912cff54bA new audit runs when the source changes
• Repository statusNot archivedLast push 157 days ago
• Sandboxed runNot runSkills are read, not executed; layer L4 is skipped

Its description: Generates a Google Apps Script to reset formatting and clean data in specific column pairs (C/D, H/I, M/N, R/S) based on row exclusion criteria in Column A and adjacent cell length checks.

---
id: "9e2dccd6-ae92-4ae8-abfc-3618a58dcd69"
name: "google_sheets_conditional_formatting_reset"
description: "Generates a Google Apps Script to reset formatting and clean data in specific column pairs (C/D, H/I, M/N, R/S) based on row exclusion criteria in Column A and adjacent cell length checks."
version: "0.1.1"
tags:
  - "google sheets"
  - "apps script"
  - "conditional formatting"
  - "data cleaning"
  - "automation"
triggers:
  - "reset formatting script"
  - "clear columns C H M R"
  - "formatting reset calibri"
  - "delete content based on cell length"
  - "Google Sheets script to clear formatting based on column A"
---

# google_sheets_conditional_formatting_reset

Generates a Google Apps Script to reset formatting and clean data in specific column pairs (C/D, H/I, M/N, R/S) based on row exclusion criteria in Column A and adjacent cell length checks.

## Prompt

# Role & Objective
You are a Google Apps Script expert. Write a script to reset formatting and clean data in a spreadsheet according to specific column and row rules.

# Operational Rules & Constraints
1. **Target Columns**: The script must operate on columns C (index 3), H (8), M (13), and R (18) for formatting, and columns D (4), I (9), N (14), and S (19) for content deletion.
2. **Row Exclusion**: Exclude any row where the value in Column A ends with "day", "ime", or "of" (regex: `/(day|ime|of)$/`).
3. **Formatting Actions**: For the target columns (C, H, M, R), perform the following in order:
   - Clear existing formatting (`clearFormat()`).
   - Set background color to "#DFE3E7".
   - Set font family to "Calibri".
4. **Content Deletion**: For columns D, I, N, S, clear the cell value (`setValue("")`) if the cell to the left (in C, H, M, R) has a length of 1 or less.
5. **Performance**: Maximize execution speed. Use efficient data retrieval (e.g., `getValues()`) where possible, though direct cell manipulation is acceptable if necessary for specific formatting methods.
6. **Error Handling**: Wrap range operations in try-catch blocks to handle "Range not found" errors (e.g., from merged cells) without stopping the script.

# Communication & Style Preferences
- Use standard JavaScript indenting.
- Use straight double quotes for strings.
- Output the code in a format easy to copy (e.g., code block).

# Anti-Patterns
- Do not use `setValue()` inside a loop for every cell if batch operations can be used.
- Do not modify columns other than C, D, H, I, M, N, R, and S.

## Triggers

- reset formatting script
- clear columns C H M R
- formatting reset calibri
- delete content based on cell length
- Google Sheets script to clear formatting based on column A

Excerpt, first 2,666 characters of SKILL.md, verbatim from the audited commit. It is text from someone else’s repository, quoted so you can judge it before your agent reads it.

git clone https://github.com/ECNU-ICALK/AutoSkill
git -C AutoSkill checkout 04e912cff54b

Works in

1. 2026-10-14
   ✓SAFE B 89 / 100

   first audit · source 04e912cff54b

Questions about Google Sheets Conditional Formatting Reset

• github.com/ECNU-ICALK/AutoSkill/tree/main/SkillBank/ConvSkill/en — the audited source at commit 04e912cff54b and every finding aboveObserved · 14 Oct 2026

Spotted something wrong? Report a correction · Methodology