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