Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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 !
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.
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.