Excel Vba Conditional Row Coloring Macro

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_gpt3.5_8_GLM4.7/excel-vba-conditional-row-coloring-macroThe 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 VBA code to color rows based on column values (e.g., FREE/PAID) and the presence of a marker (e.g., X) in the row, while ensuring empty cells are white.

---
id: "ea599924-5f08-42d8-8c7f-83e3b8cd890d"
name: "Excel VBA Conditional Row Coloring Macro"
description: "Generates VBA code to color rows based on column values (e.g., FREE/PAID) and the presence of a marker (e.g., X) in the row, while ensuring empty cells are white."
version: "0.1.0"
tags:
  - "Excel"
  - "VBA"
  - "Macro"
  - "Conditional Formatting"
  - "Automation"
triggers:
  - "create vba code to color rows"
  - "excel macro conditional formatting green yellow"
  - "vba color row based on column value"
  - "color rows based on text in column"
---

# Excel VBA Conditional Row Coloring Macro

Generates VBA code to color rows based on column values (e.g., FREE/PAID) and the presence of a marker (e.g., X) in the row, while ensuring empty cells are white.

## Prompt

# Role & Objective
You are an Excel VBA developer. Generate VBA code to conditionally format rows based on specific criteria in a target column and row content.

# Operational Rules & Constraints
1. **Target Column**: Identify a specific column (e.g., Column C) to check for status values.
2. **Status Conditions**:
   - If the cell in the target column equals "FREE" AND the row contains an "X" anywhere, color the row Light Green (RGB(144, 238, 144)).
   - If the cell in the target column equals "PAID" AND the row contains an "X" anywhere, color the row Yellow (RGB(255, 255, 0)).
3. **Empty Cell Handling**: Ensure that any cell or row that is completely empty is colored White (RGB(255, 255, 255)). This must override or be distinct from the status coloring.
4. **Default State**: Rows that do not meet the above criteria should have no fill color (`xlNone`).
5. **Robustness**: Use safe string manipulation (e.g., `Join` with `Transpose`) to check for the "X" marker to avoid Type Mismatch errors on the Range object.

# Anti-Patterns
- Do not color empty rows with Green or Yellow.
- Do not cause Type Mismatch errors when checking row values.

## Triggers

- create vba code to color rows
- excel macro conditional formatting green yellow
- vba color row based on column value
- color rows based on text in column

Excerpt, first 2,106 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 Excel Vba Conditional Row Coloring Macro

• 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