Excel Filtering Highlight Macro

Заказчик: AI | Опубликовано: 13.01.2026
Бюджет: 30 $

I need a clean, well-commented VBA macro that will scan four specific columns—Application (C), Entitlement Display Name (F), Entitlement Value (G) and Entitlement Description (H)—apply a series of exact-match text rules I will supply, and then handle the data as follows: • Any row that hits a rule is highlighted in red and receives a code such as “Rule 1a” in a new “Exclusion Reason” column. • All other rows turn green to show they survived the check. • Excluded rows should also be copied (or moved—let me choose in the code) to a separate sheet for easy review. • A new column must concatenate Asset ID with Entitlement Value so downstream tools have a unique key. Please write this entirely in VBA; I want the logic embedded inside the workbook so colleagues without Python can run it with a single button. Include clear comments and a short setup note so anyone can adjust rule text or colours later. Deliverables 1. The VBA module (.bas or embedded workbook) with clear in-line comments. 2. A brief read-me or doc inside the workbook explaining where to edit rule lists, colour values (red for exclusion, green for inclusion), and the optional move/copy choice. 3. A sample run showing the cleaned, colour-coded data with the “Exclusion Reason” and the concatenated key in place. If something is unclear, feel free to ask before you code—getting the rule logic right is more important than rushing.