conditional-formatting
/conditional-formatting
Use formatting rules to surface exceptions and patterns automatically, without turning the sheet into a colour chart. Use when readers need to spot outliers or status at a glance.
- Author
- Amey-Thakur ↗
- Repository
- AI-SKILLS ↗
- Licence
- MIT
- Last repository change
- 05.09.2026
Assessment and security
- Files in this package
- 1
- Scripts
- 0
- HTML comments
- 0
- URLs in SKILL.md
- 0
No signals detected. Repository changed on 05.09.2026, without references to retired models or APIs.
MIT, open: use and modify while retaining author attribution.
What it does and when to use it
Use formatting rules to surface exceptions and patterns automatically, without turning the sheet into a colour chart. Use when readers need to spot outliers or status at a glance.
Original author description
Use formatting rules to surface exceptions and patterns automatically, without turning the sheet into a colour chart. Use when readers need to spot outliers or status at a glance.
How it works
- Method
- Boundaries
SKILL.md preview
--- name: conditional-formatting description: Use formatting rules to surface exceptions and patterns automatically, without turning the sheet into a colour chart. Use when readers need to spot outliers or status at a glance. --- # Conditional formatting Formatting rules make a sheet self-monitoring: values crossing a threshold highlight themselves. Overused, they produce a rainbow that communicates nothing. ## Method 1. **Highlight exceptions, not everything.** Colour applied to a minority of cells draws the eye; colour everywhere is wallpaper. 2. **Use formula-based rules for real conditions.** Rules referencing other cells express the actual business condition rather than a simple value test. 3. **Keep the palette small and meaningful.** Two or three colours with consistent meaning across the workbook, since inconsistent colour coding actively misleads. 4. **Never rely on colour alone.** Add an icon or a text flag, because colour-only meaning excludes many readers and fails in print (see color-contrast). 5. **Apply to ranges, not cell by cell.** Rules multiplied across thousands of individual cells slow recalculation and become unmanageable (see spreadsheet-performance). 6. **Document what the colours mean.** A small legend on the sheet, since a reader cannot inspect rules to find out. 7. **Review rules periodically.** Accumulated overlapping rules produce unpredictable results as they layer. ## Boundaries Formatting draws attention and does not enforce anything, so it complements validation rather than replacing it (see data-validation-rules). Many rules degrade performance. Formatting is lost or altered when exporting to other formats.
Versions
The database has no other skills named conditional-formatting.
Database snapshot: 13.11.2026 · package version f714d060516c (SHA-256 digest of the entire package)
Downloads in the last 30 days: 0 · ranking
Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.
Similar skills
- 90Power BI Themes
Apply, inspect, and compare Power BI report themes and conditional formatting rules using pbi-cli. Invoke this skill whenever the user mentions "theme", "colours", "colors", "branding", "dark mode", "corporate theme", "styling", "conditional formatting", "colour scale",… - 100power-bi-themes
Apply, inspect, and compare Power BI report themes and conditional formatting rules using pbi-cli. Invoke this skill whenever the user mentions "theme", "colours", "colors", "branding", "dark mode", "corporate theme", "styling", "conditional formatting", "colour scale",… - 100wps-conditional-format
表格自动变色。想让低于60分的自动变红?想加个进度条效果?想要红绿灯图标? 帮你设置条件格式,数据条、色阶、图标集、重复值高亮,还提供JSA宏代码。 用于帮助用户设置表格条件格式。当用户提到条件格式、自动变色、数据条、红绿灯时触发。 Conditional formatting expert - data bars, color scales, icon sets, and rules.