Help about write color text by QTP in Excel

[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