| 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
- Target Column: Identify a specific column (e.g., Column C) to check for status values.
- 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)).
- 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.
- Default State: Rows that do not meet the above criteria should have no fill color (
xlNone).
- 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
