Hey!
We truly hope that our free tool comes in handy for your business, especially these days. Follow our news, stay safe & pivot on!

Conditional Formatting for a row & export

Answered

Hi,
I am loving your work.
I am trying to display an evolution between 2 data sets. I was able to do it but using CSS as follow : https://codepen.io/webdatarocks/pen/MxEdZx
 
Unfortunately at export the coloring disappeared. I there a way to keep the coloring as shown for conditional formatting?
Another idea I had, I could add a column with a number:
1 if no change and
2 if changes.
Can the full row be colorized based on one cell (and using conditional formatting)? It would not be as good since it not cell based but would at least be something.
 
Thanks in advance to anyone that could help.
Max

3 answers

Maxime September 27, 2020

I think I need to clarify.
It’s xlsx export, and when exporting conditional formatting the xlsx keeps the cell coloring but not using css. I would like to understand how that works to find a fix.

WebDataRocks Team WebDataRocks October 20, 2020

Hi, Maxime!
 
Thank you for your kind words about our product and for your questions.
 
1. Is there a way to keep the coloring as shown for conditional formatting?
We would like to kindly mention that the coloring shown in the example can not be achieved with the conditional formatting. Our team suggests exporting the grid to the server and coloring the cells in the Excel file on the backend.
 
2. Another idea I had, I could add a column with a number: 1 if no change and 2 if changes.
Could you please elaborate more on the expected behavior? A screenshot or an example would greatly help us in our investigation.
 
3. Can the full row be colorized based on one cell (and using conditional formatting)?
The described functionality can be configured with the use of the customizeCell method, but not with conditional formatting. Please kindly note that customizeCell does not apply coloring to the exported file.

As you mentioned that the “not cell-based” solution will partly help, we have prepared an example with the formatting applied to the specific row based on the row number. The formatting will also appear in Excel. Please have a look: https://codepen.io/webdatarocks/pen/RwRRjjX.
 
Hope it helps!
 
Best regards,
WebDataRocks Team

Maxime 5 days ago

Good morning,
Thank you so much for your answer. I will be studying it and get back to you.
 
Sincerely,
Max

Please login or Register to Submit Answer