[R] Colors according to value (Excel-Export)

Mat matthias.weber at fnt.de
Thu Dec 6 14:48:23 CET 2012


Hello together,

i have a list of numbers, like this one
A    B     C
1.1 1.2  1.3

i export this list into an excel file and want now color these numbers
according to her value.
I want every color under 1,25 is red, and every color over 1,25 is green.

How can i do this with "RDCOMClient" ?

I know how to colour a complete row, like this task:

U3R <- sh$Range(zellen_blue)
U3RF <- U3R$Font()
U3RF[["Bold"]] <- TRUE
U3RF[["Size"]] <- "10"
U3RF[["Color"]] <-"-10526881"

but how can i color numbers accordung to her value?

Thanks.

Mat



--
View this message in context: http://r.789695.n4.nabble.com/Colors-according-to-value-Excel-Export-tp4652331.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list