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

  • YouGov
  • SevenOne Media
  • Mediengruppe RTL Deutschland
  • Nielsen Sports
  • mobile.de
  • 50+ interactive chart types
  • 20+ statistical methods
  • SPSS · Excel · CSV import without data loss
  • 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

Top rated

4.5 out of 5 stars on G2 and OMR Reviews

What users say about DataLion

  • Very professional company, attentive to the customer needs, provider of a great software and service.
    Generoso M. CRM Analyst · Automotive via G2
  • The contacts at DataLion are very committed. If you have problems, you can count on help. DataLion reacts quickly to requests for new functions.
    Robert Q. Managing Director via G2
  • User-friendliness, especially for market research topics. Structured backend with many customization options.
    Verified user Market Research via G2
  • The embedding function allows us to generate insights of our data for our audience and customers by far less than half of the usual time needed before.
    Verified user Leisure, Travel & Tourism via G2
Read all 16 reviews on G2 →
We now work much more efficiently, giving us more time to take care of the derivations and insights from the data for the customers.
Jens Falkenau, Vice President of Market Research · Nielsen Sports
Read the case study →

More on tables & reporting

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.

Try it free Book a demo