Skip to main content
Glama
WilliamSmithEdward

xlide-excel-word-powerpoint-access-office-vba-mcp

Conditional formatting

xlide_manage_conditional_format
DestructiveIdempotent

List, add, or clear conditional formatting rules in Excel files to color cells by value comparisons, formulas, color scales, or data bars.

Instructions

Lists, adds or clears conditional formatting: the rules that colour cells by what is in them. rule='cell_is' with an operator and a value paints cells that compare true; rule='expression' takes a formula written for the top-left cell of the range and applied relatively, the way Excel's 'Use a formula' box works; rule='color_scale' and 'data_bar' are the gradient and in-cell bar. The paint itself is the fill and font arguments, which is what Excel calls a differential format.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
boldNoMake matching cells bold.
ruleNocell_is, expression, color_scale or data_bar.cell_is
sheetYesWorksheet name, matched without case.
valueNoFor cell_is: the value compared against.
actionNolist, add or clear.list
formulaNoFor expression: a formula for the range's top-left cell.
operatorNoFor cell_is: greaterThan, between, etc.greaterThan
file_pathYesAbsolute path to the Excel file.
cell_rangeNoFor add and clear: the range. Empty clears the whole sheet.
fill_colorNoFill to paint matching cells, as hex.
font_colorNoText colour for matching cells, as hex.
other_valueNoFor cell_is with between: the second value.

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault

No arguments

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.1.0

TDQS

A4.4/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already signal non-read-only, destructive, and idempotent behavior; the description adds meaningful behavior beyond that by explaining how rule types behave: cell_is compares values, expression formulas are applied relatively from the top-left cell, and color_scale/data_bar are gradient and in-cell bar formats. This gives the agent a mental model of the mutation's semantics rather than only its safety profile.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is two dense sentences with no filler. It front-loads the primary action, then systematically explains each rule type in an efficient, readable progression. Every sentence contributes necessary semantics.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the 12-parameter complexity, the schema's 100% coverage, and the presence of an output schema, the description supplies the missing conceptual glue: what each rule mode means and how fill/font relate to Excel's differential formats. It does not fully map every parameter combination per action, but it gives enough orientation for an agent to use the schema confidently.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Although schema coverage is 100%, the description elevates the parameters by providing the conceptual framework: 'rule', 'operator', 'value', 'formula', 'fill_color', and 'font_color' are tied to actual Excel conditional-formatting behavior. It adds meaning beyond the terse schema field descriptions, such as the relative-formula semantics of 'expression' and the 'differential format' notion for fill/font.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description opens with a specific verb-resource pair — 'Lists, adds or clears conditional formatting' — and then defines exactly what conditional formatting is: rules that colour cells by their contents. It clearly separates this from sibling formatting tools like xlide_format_cells by focusing on rule-driven, condition-based formatting.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description makes the tool's domain unmistakable: use it whenever conditional formatting rules need to be listed, added, or cleared. It does not explicitly name alternatives or say when not to use it, but the context is clear enough that an agent can route to this tool without confusing it with static formatting or validation siblings.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.