# 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.

- Skill: `ecnu-icalk/excel-vba-conditional-row-coloring-macro` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/excel-vba-conditional-row-coloring-macro`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/excel-vba-conditional-row-coloring-macro/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: ECNU-ICALK (https://skillmd.com/u/ecnu-icalk)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/ecnu-icalk/excel-vba-conditional-row-coloring-macro

---


# 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