R help - Dec 2012 - Colors according to value (Excel-Export)

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.

i tried it this way, but this won't help.

O3R <- sh$PT_IST(zellen_other)
O3RF <- O3R$Font()
O3RF[["Bold"]] <- TRUE
O3RF[["Size"]] <- "10"
O3RF[["Color"]] <-"5287936"

perhabs you can help me, how i can differenz between the values of more and
less than 1,25?

Thanks. 

Mat



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

here is one:
i have this in my excel sheet
                                               PT_IST
Projekt A                                 1,1
Projekt B                                1,15
Projekt C                                 1,2

Difference				1,15

This number is generated from the data above and is ok.
The Excel sheet was generated every day. And the numbers can change from day
to day.
I know how to color the whole row, but i don't know how to color the number
"Difference --> 1,15" according to her value, like: if>1,2 <-
RED, if <1,2
<- GREEN

Thanks. 

Mat




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

i tried it this way. With this Code the Row "Difference" gets complete
green.
But i want the color change to red according to a different value.

highlight_other<-out.ex1[(out.ex1$AUFTR_NAME=="Difference"),]$LFD2
zellen_other<-paste(paste("A",highlight_other,sep=""),paste("S",highlight_other,sep=""),sep=":")


# Libray
library(RDCOMClient)

#Start Excel
xl <- COMCreate("Excel.Application")  

#?ffnen von Excel
xl[["Visible"]] <- FALSE                      
xl[['DisplayAlerts']] <- FALSE 	 

#Datei ?ffnen
wkbk <- xl$Workbooks()$Open(pfad)       
 
#Formel einf?gen
sh <- xl$ActiveSheet()

#Difference
O3R <- sh$Range(zellen_other)
O3RF <- O3R$Font()
O3RF[["Bold"]] <- TRUE
O3RF[["Size"]] <- "10"
O3RF[["Color"]] <-"5287936"




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