Conditional formatting for tables

Colour cells by rule: map the operators =, <, >, <= and >= to a hex colour per column. The formatting is preserved in PowerPoint and PNG exports.

Try DataLion free

DataLion table with conditional formatting colouring cells by value

Conditional formatting colours table cells by rule in DataLion. You map the operators =, <, >, <= and >= to a hex colour per column or subcolumn. The formatting is preserved in PowerPoint (PPTX) and PNG exports and pairs with heatmaps and tables.

🇩🇪 Made in Munich
GDPR-compliant
DPA included
Hosted in Germany

Trusted by research, insights & media teams

50+ interactive chart types
20+ statistical methods (R)
2 weeks release cadence
ISO 27001 certified data centers (Germany)

Colour cells by rule

Define rules that make your table speak: with the operators =, <, >, <= and >= you set which value gives a cell which colour — say green for a top-2 box above target, red below it.

Readers spot what stands out immediately, without reading every figure one by one. A bare table becomes a traffic-light system that tells the story itself.

Operators =, <, >, <= and >= per rule
Freely definable thresholds
Outliers visible at a glance

DataLion table with cells coloured green and red by threshold

Hex colours per column and subcolumn

You choose the colours yourself — as hex values, exactly in your corporate design. And you control them precisely: per column and subcolumn, so different metrics get their own logic.

The colouring of a satisfaction column can differ from the one for recommendation — each metric by its own thresholds.

Free hex colours in your own CI
Rules per column and subcolumn
Own logic per metric

DataLion table configuration with hex colours per column and subcolumn

Colours survive the export — PowerPoint & PNG

The best part: conditional formatting is not just a screen effect. It is preserved in the PowerPoint export (PPTX) and the PNG export — the coloured cells arrive in your deck exactly as you set them.

Conditional formatting also pairs beautifully with heatmaps and crosstabs. Learn more on the Heatmaps and Crosstabs pages.

Formatting preserved in the PPTX export
Formatting preserved in the PNG export
A perfect complement to heatmaps and crosstabs

See DataLion with your own data

Start a free trial or book a personal demo — from raw data to a finished dashboard.

Try it free Book a demo

**Jens Falkenau**, Vice President of Market Research · Nielsen Sports

Common questions about conditional formatting

How does conditional formatting work in DataLion?

You define rules with the operators =, <, >, <= and >= and map each rule to a hex colour. When a cell value satisfies the rule, the cell is coloured accordingly — controllable per column and subcolumn.

Which operators are available for the rules?

Equal to (=), less than (<), greater than (>), less than or equal (<=) and greater than or equal (>=). These cover thresholds and value ranges.

Can I use my own colours?

Yes. You set the colours as hex values, exactly in your corporate design. The mapping works per column and subcolumn, so each metric gets its own logic.

Is the formatting preserved on export?

Yes. Conditional formatting is preserved in the PowerPoint export (PPTX) and the PNG export — the coloured cells appear in your deck or image exactly as set.

What does conditional formatting pair best with?

Crosstabs and heatmaps. Combined, they make outliers in large tables instantly visible, with no need to read every figure one by one.

Bring colour to your tables

Try DataLion free — or get a demo of how conditional formatting makes your tables readable and survives the export.