Comparison between two excel tabs

[SJord]

Hi all! I am looking for some help in making a macro that can compare two excel tabs and highlight the differences between the two automatically.
Short explanation is a schedule is made at the start of the week constituting of multiple columns and rows of data, which I can export to an excel document, then half way through the week i will be exporting it again and need to compare differences between the two.

Any help would be greatly appreciated.

 

[Jeffrey Mahoney]

Use conditional formatting. Are the cells related to each in the same cell address? Easy. If not, then a CF formula could be created to compare the results. Can you show us your tables using XL2BB?

Congrats on your first post here!

 

[SJord]

Hi Jeffrey,

Thanks for pointing me in the right direction. I was able to get a really good solution! Cheers.