Help about write color text by QTP in Excel

Help about write color text by QTP in Excel - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: Help about write color text by QTP in Excel (/Thread-Help-about-write-color-text-by-QTP-in-Excel)

Help about write color text by QTP in Excel - mantis - 12-29-2011

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!!! Smile

RE: Help about write color text by QTP in Excel - sshukla12 - 12-29-2011

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