I'm creating a Comparator script in QTP where it will import 2 Excel files in to two sheets in the QTP DataTable, perform a cell by cell comparison, report discrepancies (tells which row and column with discrepancy) in a new sheet, then Export the 3 sheets to a new Excel file.
I think it would be cool and helpful if I could link the cell with discrepancy from my report sheet to one of the sheets that is being compared itself. It would be even cooler if I could highlight or fill that cell with color.
I have seen it being done... how do I do that?!