Dan Purcell
asked on
Need to compare data and highlight incorrect
I have an issue where some exported data changed. I need to line up a column of correct data next to the exported data and compare. What I would like is a macro that highlights the non-matching cells. Attached is a sample sheet with 1 row not matching. This is based on same row data.
I think you forgot to upload the file.
ASKER
Thanks.
Book1.xlsx
Book1.xlsx
Why do you need VBA? A simple formula will do.
Book1--1-.xlsx
Book1--1-.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That will work perfect. The only reason for macro is future use but I could reefer to this
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
Just seen Rob's suggestion, that will work faster than a macro as well, might take a little more time to set up though.
Likewise, adding the conditional formatting only took seconds and will do the highlight as required.
ASKER
Thanks for your quick help
Pleased to help
Glad to help
ASKER
I would need to be able to do it post export on a regular bases to ensure my customer my verifying the export