Skip to content
Skills Library
Documents & office · Building & coding

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.

Repository
AI-SKILLS ↗
Licence
MIT
Last repository change
05.09.2026

Assessment and security

90/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content25 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
1
Scripts
0
HTML comments
0
URLs in SKILL.md
0
Deprecation

No signals detected. Repository changed on 05.09.2026, without references to retired models or APIs.

Licence

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

  1. Method
  2. Boundaries
Original SKILL.md headings · 35 lines, 204 words
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.

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.