It works but it wont evaluate the condition as it is a string,
but I tried this

VAL(TRANSFORM(oExcel.Cells[nRow, 9].Value)) <= 3.2

and intrestingly enough it worked!!


>Tamas,
>
>What I suggested should have worked regardless of the type of the cell. In other words,

transform(value) <="3.2"

>
>
>>Thanks everyone for you answers!
>>
>>I rechecked and tried the followings:
>>
>>

>>FOR nRow = 1 TO  oExcel.ActiveWorkBook.ActiveSheet.UsedRange.Rows.Count
>>    IF oExcel.Cells[nRow, 9].Value <= 3.2
>>          oExcel.Cells[nRow, 2].Interior.Color = RGB(255,153,255)
>>    ENDIF
>>ENDFOR
>>

>>didnt work, same error message.
>>
>>

>>FOR nRow = 1 TO  oExcel.ActiveWorkBook.ActiveSheet.UsedRange.Rows.Count
>>    IF oExcel.Cells[nRow, 9].Value <= "3.2"
>>          oExcel.Cells[nRow, 2].Interior.Color = RGB(255,153,255)
>>    ENDIF
>>ENDFOR
>>

>>didnt work either, same error message.
>>
>>I also tried what Hilmar suggested: checked the condition if it is numeric.
>>I put it in a variable like this ...
>>

>>? TYPE("oExcel.Cells[2,9].Value")
>>

>>and it turned out to be numeric.
>>
>>I didnt understand why it works with a character data type field and gives error with numeric.