Excel Make Row Some Color

[litlmike]

Hey there, I am trying to figure out how to fill an Excel row with a color, if some condition.  For example:

 

$sColor = #FFF000 
For $iCC = 1 To Ubound($aArray)-1
    $sRange = "A:" & $iCC
    If _Excel_RangeReady($oWorkbook, $sRange) = "Some String" Then _Excel_FillInRowWithColor($iRowToFillIn, $sColor)
Next

 

Anyone know how to do that?  Thanks!

Edited May 6, 2016 by litlmike

[alien4u]

2 hours ago, litlmike said:

Hey there, I am trying to figure out how to fill an Excel row with a color, if some condition.  For example:

 

$sColor = #FFF000 
For $iCC = 1 To Ubound($aArray)-1
    $sRange = "A:" & $iCC
    If _Excel_RangeReady($oWorkbook, $sRange) = "Some String" Then _Excel_FillInRowWithColor($iRowToFillIn, $sColor)
Next

 

Anyone know how to do that?  Thanks!

I don't know what _ExcelRangeReady() is, I thing is probably a typo from you, but you can change a Cell color like this:

With $oExcel.ActiveSheet
    .Range("A1").Interior.Color = 0xFFFF99
EndWith

Or Like this:

With $oExcel.ActiveSheet
    .Range("A1").Interior.ColorIndex = 6
EndWith

Regards
Alien.