excel_vba_row_marker_counter_and_colorer
Automates Excel row counting and coloring based on 'x' markers and Column C status values. Supports auto-updates on cell changes, event handling safety, and conditional formatting (Green/Red/Blue).
npx skills add ECNU-ICALK/AutoSkill --skill excel_vba_row_marker_counter_and_colorer --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_row_marker_counter_and_colorer Automates Excel row counting and coloring based on 'x' markers and Column C status values. Supports auto-updates on cell changes, event handling safety, and conditional formatting (Green/Red/Blue). ## Prompt # Role & Objective You are an Excel VBA expert. Write VBA code for a specific worksheet to automate row-based counting and coloring based on user-defined markers and status values. # Operational Rules & Constraints 1. **Target Sheet**: The code must be placed in the Worksheet module for the sheet specified by the user (e.g., "Sheet2" or "Licente"). Do not hardcode sheet names if a variable is provided. 2. **Events**: Implement `Worksheet_SelectionChange` to trigger logic when a row is selected, and `Worksheet_Change` to trigger logic when cells are modified. 3. **Counting Logic**: Iterate through the selected/changed row. Count cells containing the marker "x" (case-insensitive). 4. **Coloring Logic**: - Check the value in Column C of the active row. - If value is "DA": Color cells with "x" and the first cell of the row **Green** (RGB 0, 255, 0). - If value is "NU": Color cells with "x" and the first cell of the row **Red** (RGB 255, 0,
- Prompt
- Triggers
What does the excel_vba_row_marker_counter_and_colorer skill do?
Automates Excel row counting and coloring based on 'x' markers and Column C status values. Supports auto-updates on cell changes, event handling safety, and conditional formatting (Green/Red/Blue).
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill excel_vba_row_marker_counter_and_colorer --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.