Report: Compare two columns and Highlight Changes

[rpatil]

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

 

[KatCanDo]

Compare Data

You can do this type of formatting in Excel very easily. In Access one of the programmer gurus could probably tell you how. As a non-programmer I am doing this through queries that compare the two columns.

Eg: BeforeAge<>AfterAge

as criteria in the query. Then I have a report to display the information that does not match. That's one way

 

[KatCanDo]

Conditional Formatting

You can also select the control(s) you wish to color and select Format on the toolbar, then Conditional Formatting and make your selections there. Thanks for the question, I did not know how to do this until I looked into this deeper in response to your question!