Hello !
I am creating a report and then exporting it to Excel using the openxlsx package. Although I was able to include all necessary formats, I am struggling with the table title. The title of this table needs to have mixed colors - black and red. I am using the writeData function to add the title in 4 merged cells above the table, but I am unable to make it with black color for the first part of the title and red for the second part. The Cat function can partially color the desired text, but it can only be printed in the console and cannot be passed in the cell as a string where I am creating the title.
Any suggestion would be helpful.
Hi, have you had a look at the conditional formatting vignette?
2 Likes
Thank you, very helpful project, although I need to explore more to solve my scenario.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
If you have a query related to it or one of the replies, start a new topic and refer back with a link.