Coloring / highlighting rows and exporting in Excel

[tomtom]

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.

[Ferdma]

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 !

[t0mt0m]

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.