Hello,
I have a table of data which I would like to conditionally format all the columns individually (change background colour depending on the value e.g. >4 = green, <4 = red in the first column, <5 = green and >5 = red in the 2nd column etc…) then export it ideally to a powerpoint type format. However the table must also be transposed.
I have tried several different methods:
- Transposing the table, then using CSS editor, but the export seems to only work as javascript
- Transposing the table then exporting to BIRT, but highlighting a table in BIRT only works on columns
- Using XLS coloured writer to format the table and export it as a transposed table, which is OK for excel, but then I need to copy and paste it into slides.
If there any way to do this?
Thanks,
Sian