[R] Package recommendations for outputting table with cell formatting

Patrick (Malone Quantitative) m@|one @end|ng |rom m@|onequ@nt|t@t|ve@com
Sat Oct 24 03:15:25 CEST 2020


Will this need to be done many times? If not, it might be just as easy
to apply conditional formatting to cells after they're already in
Excel.

On Fri, Oct 23, 2020 at 8:28 PM Dennis Fisher <fisher using plessthan.com> wrote:
>
> R 4.0.2
> OS X
>
> Colleagues
>
> I have the unfortunate need to create a large number of tables (destined for a Word document).  I need to color cells depending on the contents, e.g., blue if the value is < 0.5, red if the value is > 1.5.
> If the output went initially to Excel, that would work; outputting directly to Word would be even better.
> I expect that several packages can accomplish this.  I am looking for recommendations as to which package (or combination) of packages is best to accomplish this.
>
> Dennis
>
> Dennis Fisher MD
> P < (The "P Less Than" Company)
> Phone / Fax: 1-866-PLessThan (1-866-753-7784)
> www.PLessThan.com
>
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.



-- 
Patrick S. Malone, Ph.D., Malone Quantitative
NEW Service Models: http://malonequantitative.com

He/Him/His



More information about the R-help mailing list