Am 29.08.2013 12:08 (UTC+1) schrieb Zsurzsa Laszlo: > Dear R users, > > I have a question about the xlsx package. It's possible to create excel > files and color cells and etc.
yes, with package xlsx you can colourize you data sheets, even the fonts. See for example ?CellStyle . A good demonstration of the capabilities is on http://tradeblotter.wordpress.com/2013/05/02/writing-from-r-to-excel-with-xlsx/ > > My question would be that is it possible to color only some part of the > data hold in a cell. Let's assume I've got the following data : > 167,153,120,100 and I want to color to red everything that is bigger then > 120. How can I achive this using R. > > Example file setup with a few lines in attachment. (SEL_MASS column can be > used for example) Attachment missing ... HTH, Rainer > > Thank you in advance, > ------------------------------------------------------------------------------------- > - László-András Zsurzsa, - > - Msc. Infromatics, Technical University Munich, Germany - > - Scientific Employee, TUM - > ------------------------------------------------------------------------------------- ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
