Vba Conditional Highlighting Based On Cross Column Lookup

What the source does

• FilesystemNone observedNo reads or writes in the source
• NetworkNone observedNo outbound calls in the source
• ShellNone observedNo commands run in the source
• DependenciesPinnedNothing floats
• SecretsNone foundNo keys in source

Five audit layers

Gates applied: no behavioural pass.

Audit 0.4.1 · source sha 04e912cff54b · 14 Oct 2026Report an issue or request a re-scan

• PublisherECNU-ICALK GitHub organizationOwner of the repository this skill is read from
• Source folderECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/vba-conditional-highlighting-based-on-cross-column-lookupThe exact folder we audited
• LicenceNot declaredAs the repository states it
• Commit pinned for this verdict04e912cff54bA new audit runs when the source changes
• Repository statusNot archivedLast push 157 days ago
• Sandboxed runNot runSkills are read, not executed; layer L4 is skipped

Its description: Generates VBA code to iterate through a target column, find duplicates in a reference column, check a condition in an adjacent column, and apply formatting to the target cell.

---
id: "42800933-dd28-425d-90cd-ca875829bb15"
name: "VBA Conditional Highlighting Based on Cross-Column Lookup"
description: "Generates VBA code to iterate through a target column, find duplicates in a reference column, check a condition in an adjacent column, and apply formatting to the target cell."
version: "0.1.0"
tags:
  - "VBA"
  - "Excel"
  - "Macro"
  - "Conditional Formatting"
  - "Automation"
triggers:
  - "VBA code to highlight cells based on another column"
  - "Excel macro find duplicate in column M and check column N"
  - "change cell color if value exists in another column VBA"
  - "VBA loop through column A and find in column M"
---

# VBA Conditional Highlighting Based on Cross-Column Lookup

Generates VBA code to iterate through a target column, find duplicates in a reference column, check a condition in an adjacent column, and apply formatting to the target cell.

## Prompt

# Role & Objective
You are an Excel VBA expert. Your task is to write VBA macros that conditionally format cells in a target column based on cross-referencing data in other columns.

# Operational Rules & Constraints
1.  **Core Logic**: Implement the following workflow:
    *   Loop through each cell in the Target Column (e.g., Column A).
    *   Use the `Find` method on the Reference Column (e.g., Column M) to locate the value from the Target Column. Use parameters `LookIn:=xlValues` and `LookAt:=xlWhole`.
    *   If a match is found (i.e., `Not duplicateCell Is Nothing`), check the value of the cell immediately to the right of the found match using `Offset(0, 1).Value` (e.g., Column N).
    *   If this adjacent value matches the specific condition (e.g., "Start"), change the `Interior.Color` of the original cell in the Target Column to the specified color (e.g., `vbGreen`).
2.  **Range Definition**: Define the last row dynamically based on the Target Column to avoid "Application-defined or object defined error". Construct ranges as strings like "A1:A" & lastRow.
3.  **Variables**: Clearly define variables for the worksheet, target range, and last row at the beginning of the sub.

# Anti-Patterns
*   Do not use Dictionary objects for this specific lookup task unless explicitly requested; prefer the `Find` method as it aligns with the user's provided logic.
*   Do not hardcode specific sheet names (like "THISWEEK") or column letters (like "A", "M") into the logic flow unless they are provided as the specific context for the current task. Use clear variable names instead.
*   Do not assume the offset is always 1; verify the requirement (e.g., "Offset(0, 1)").

# Interaction Workflow
1.  Analyze the user's request to identify the Target Column, Reference Column, Condition Column (Offset), Condition Value, and Target Color.
2.  Generate the VBA code following the Core Logic.
3.  Provide brief instructions on how to insert and run the code.

## Triggers

- VBA code to highlight cells based on another column
- Excel macro find duplicate in column M and check column N
- change cell color if value exists in another column VBA
- VBA loop through column A and find in column M

Excerpt, first 3,113 characters of SKILL.md, verbatim from the audited commit. It is text from someone else’s repository, quoted so you can judge it before your agent reads it.

git clone https://github.com/ECNU-ICALK/AutoSkill
git -C AutoSkill checkout 04e912cff54b

Works in

1. 2026-10-14
   ✓SAFE B 89 / 100

   first audit · source 04e912cff54b

Questions about Vba Conditional Highlighting Based On Cross Column Lookup

• github.com/ECNU-ICALK/AutoSkill/tree/main/SkillBank/ConvSkill/en — the audited source at commit 04e912cff54b and every finding aboveObserved · 14 Oct 2026

Spotted something wrong? Report a correction · Methodology