Coloring / highlighting rows and exporting in Excel

tomtom
Level 2
Coloring / highlighting rows and exporting in Excel
Hello,

It would be nice to have a plugin that allows to color rows based on a formula or criteria, and to have the color / highlight kept when exporting to an Excel file.

Best regards.
0 Kudos
4 Replies
Ferdma
Dataiker

Hello Tomtom,

 

Not sure if such plugin could be easily implemented but what you can do right now is the following : 

- In a prepare recipe, add a column to flag the color you want that row to have based on a formula step or a flag step (lets say that is your 6th column and it contains 'RED')

- Export to Excel

- In excel, use conditionnal formatting based of a formula to color the whole line based on your 6th column (Col F), see here for how to build such formula in excel : https://trumpexcel.com/highlight-rows-based-on-cell-value/

You formula should look like '=$F1="RED"'

 

 

Hope it helps !

Guillaume Ferdmann - CSM Dataiku
t0mt0m
Level 2

Having, in DSS (prepare recipe for instance), a right-click "Color <color> lines containing '<pattern>' in this column" would be great.
There's already a "highlight" feature but it doesn't cover Excel exports.

0 Kudos
AshleyW
Dataiker

Hi @tomtom , 

With the release of 12.5, you can now format rows in an Explore based on their values and preserve that formatting when you export the dataset as an Excel file or publish it to a dashboard.

To apply conditional formatting, open an Explore, select the column menu, and go to Conditional Formatting > Color by rules. Once applied, you can also apply the color to the entire row by clicking on the column summary bar.

Screenshot 2024-02-26 at 09.41.04.png

Cheers, 

Ashley

 

0 Kudos

Thanks you rock !

0 Kudos