Help about write color text by QTP in Excel

[mantis]

Example i have 2 columns in Excel and have data in 2 columns and compare strings between 2 columns and String in Column A is not equal String in Column B.How can I write color text in Column A by QTP.Please help me .Thanks all much!!!

[sshukla12]

U can highlight the cell with the color filled in that, cretae a object of the worksheet like

Code:

set c=obj_worksheet.usedrange.Find(Text u want to search)
For each c in obj_worksheet.usedrange
    If c=Text u want to search Then
        c.Interior.ColorIndex=40
    End If
    Set c=obj_worksheet.usedrange.FindNext(c)

Next

Hope this will help u.

Regards,
Sankalp