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.

______________________________________________
R-help@r-project.org mailing list
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.

Reply via email to