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) > <mal...@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 <fis...@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@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 ______________________________________________ R-help@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.