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.
Asked
Active
Viewed 2,438 times
1 Answers
4
Loop through all the cells and make simple comparison, and highlight (change background color) cells that did not match.
Jean-François Corbett
- 36,032
- 27
- 135
- 183
Marek
- 715
- 6
- 13
-
1@Cornelius: Have you actually tried this "looping through cells"? If you have, then your code is probably still running... – Jean-François Corbett Oct 03 '11 at 08:34