Conditional Formatting Rule Audit and Cleanup Plan
Audit a sheet with messy conditional formatting rules, find duplicates, overlaps and slow rules, and get a cleanup plan without losing highlights.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
My sheet has too many conditional formatting rules and I want to clean them up safely. App: [SPREADSHEET_APP]. Sheet or workbook size: [SHEET_SIZE]. The rules, copied from the rule manager (range, formula or type, format, order, stop-if-true if shown): [RULE_LIST]. Problems I notice: [SYMPTOMS], for example slowness or colours that look wrong. Review the list and report: 1. A findings table with columns Rule number, Range, Type, Issue (duplicate, overlap, whole column range, unreachable, contradicts another rule, volatile function), Severity (high, medium, low), Suggested action. 2. Counts: total rules, duplicates, overlaps, rules applying to entire columns, rules that could be merged. 3. A proposed final rule set, in the order they should be applied, with merged formulas written out in full. 4. Why each removed rule is safe to remove, in one line, and how I can test that nothing changed (screenshots before and after, a range of sample rows). 5. A short note on performance: which patterns slow big sheets, such as volatile functions across thousands of rows ([VERIFY] for my version). Do not assume the sheet contents beyond what I have pasted. Recommend changes only; tell me to work on a copy and keep the original file. If a rule's behaviour is unclear, ask me before classifying it.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.