Message-ID: <B0860721-52FB-4E18-A18A-785545C2FC82@plessthan.com>
Date: 2020-10-24T01:35:05Z
From: Dennis Fisher
Subject: Package recommendations for outputting table with cell formatting
In-Reply-To: <CAJc=yOF7cAMnTDChbeOEsH0ZLbiYyJ=cB4J5e+gcumNWN7-vcQ@mail.gmail.com>
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 at 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 at 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 at 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