[R] Package recommendations for outputting table with cell formatting

[Dennis Fisher]

Patrick

Doing this in Excel is certainly an option.  But I would like to learn how to do it in R.

Dennis

Dennis Fisher MD
P < (The "P Less Than" Company)
Phone / Fax: 1-866-PLessThan (1-866-753-7784)
www.PLessThan.com




> On Oct 23, 2020, at 6:15 PM, Patrick (Malone Quantitative) <malone using malonequantitative.com> wrote:
> 
> 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