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.
npx skills add ECNU-ICALK/AutoSkill --skill excel-vba-conditional-row-coloring-macro --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# 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 Mis
- Prompt
- Triggers
What does the Excel VBA Conditional Row Coloring Macro skill do?
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.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill excel-vba-conditional-row-coloring-macro --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.