I would like to know if using VBA I can compare two similar excel files and shows the differences highlighting the background of cells or rows with different colors.
+4
A:
I believe you can do so. I have made few macros with similar functionality
The first idea is to loop through all the cells and make simple comparison, and highlight (change background color) cells that did not match.
You can do a lot using VBA ;)
Cornelius
2010-05-20 08:04:51
yes this is possible and done exactly like Cornelius says.
Steve Robillard
2010-05-20 08:07:02
thank you, it was easy in the end. I would only be sure to not loose time in searching a solution not reachable. ;)
marco.ragogna
2010-05-20 13:58:56