Report: Compare two columns and Highlight Changes

R

rpatil

Joined
Nov 17, 2006
Messages
12
Reaction score
0
Is it possible to compare two columns side by side to highlight/change color of difference between the two cells



I need to compare and show the changes to the record from previous version and generate a report which will highlight the changes (Rather than just saying that record has changed IT SHOULD TELL WHAT HAS CHANGED)







For example if the



Column 1 (Previous Version) :The structure contains Wire, Bolt, Stmaps etc



Column 2 (Current Version) : The structure contains Wire, Bolt, Stamps etc



Data Changed: YES



In report is should show two columns side by side and in Column 2 it should highlight "Stamps"











Please let me know



Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlight between 3 fields 4
Two Sources - One Report 3
Excel Comparing two columns 1
Compare & highlight changes between two worksheets? 2
Compare and highlight differences 2
conditional formatting in a Report 1
Compare and highlight 1
Conditional Formatting to Compare Two Sheets of Data 1

Top