I have a BIRT question. I see where you can create conditions to highlight cells as different colors - which is exactly what I need. The problem is, when I open the report in Excel the cell color/highlighting is gone.
Is there a way for me to retain this highlighting from the BIRT report in my Excel output?
I was actually just working my way through the example workflow that KNIME provides for BIRT and was trying to get the highlighted cells to remain highlighted in Excel upon export.
In this case, you need to keep the data table and remove the other items from the report to have the correct format in Excel.
Copy or cut the table and remove everything from the report and then paste the table. Now if you export the report to excel, the rows in the score column which have a value of equal or less than 50 will be in orange.