hello good morning i wanted to if you are able to color code a column in R, when outputting an excel file? for example when i output the excel file and open it the column i want to be colored id the color blue.
Asked
Active
Viewed 366 times
0
-
Have you tried https://stackoverflow.com/questions/21618556/export-data-frames-to-excel-via-xlsx-with-conditional-formatting – TTS Mar 10 '20 at 13:52
-
1Welcome to SO! Please, [edit] your question and show the code you are using to output the data, in particular which package are you using for creating Excel files. Thank you. – Uwe Mar 10 '20 at 14:05
-
What packages are you using? What have you tried? If you have nothing so far ... check out [`openxlsx`](https://cran.r-project.org/web/packages/openxlsx/), and specifically its [vignette on formatting](https://cran.r-project.org/web/packages/openxlsx/vignettes/formatting.pdf). – r2evans Mar 10 '20 at 14:18