VAL(TRANSFORM(oExcel.Cells[nRow, 9].Value)) <= 3.2and intrestingly enough it worked!!
transform(value) <="3.2">
>>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.
>>? TYPE("oExcel.Cells[2,9].Value") >>>>and it turned out to be numeric.