Thread: Comparison line / Excel

Hello to you all, I find this forum, a macro written by Mr galopin01 which is very interresting. Since I began in VB, I was wondering how can we could identify which cells were different in the workbook B, by coloring in orange for example, those that are deleted in the lining in the workbook A, and new green. Thank you for your help .

Comparing what with what? which column of which sheet with which column of which sheet? To find new cells or absent this assumes you know at least the columns containing the same data type. To find different cells this assumes that at least one column references identifying comparable records. Format for the rest red or orange or green or striped character, there is the macro recorder. In summary for a specific answer specific questions you ask!
On this: Good Sunday, I'll be on stage all day