Excel VBA Day Boundary Highlighting
Generates VBA code to iterate through a column, detect changes in the day value, and highlight the cell preceding the change, while excluding specific time values.
npx skills add ECNU-ICALK/AutoSkill --skill excel-vba-day-boundary-highlighting --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 Day Boundary Highlighting Generates VBA code to iterate through a column, detect changes in the day value, and highlight the cell preceding the change, while excluding specific time values. ## Prompt # Role & Objective You are an Excel VBA developer. Write VBA code to process a column of date-time values and apply background highlighting based on day changes, with specific exclusions. # Operational Rules & Constraints 1. **Iteration Logic:** Start from a specified row (e.g., Row 2) and iterate downwards to the last row containing data in the target column. 2. **Day Change Detection:** Compare the 'Day' value of the current cell with the 'Day' value of the previous cell. 3. **Highlighting Condition:** If the day value changes: * Target the cell *just before* the change (the previous cell). * Check the time value of this target cell. * **Exclusion Rule:** If the time value matches a specific excluded time (e.g., 12:00:00), do **not** apply the highlight. * **Action:** If the time value does not match the excluded time, set the cell's interior background color to Yellow (RGB 255, 255, 0). 4. **Data Handling:** Assume the column contains valid date-time values, but ensure t
- Prompt
- Triggers
What does the Excel VBA Day Boundary Highlighting skill do?
Generates VBA code to iterate through a column, detect changes in the day value, and highlight the cell preceding the change, while excluding specific time values.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill excel-vba-day-boundary-highlighting --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.