Compare two spreadsheets data and highlight differences

[ronanbaker1]

Hi Guys,

I need a macro that will search sheet1 vs sheet2 for all data in each column and row (multiple columns and rows). The rows do not match up 1 for 1. For example on sheet1 it could be row 10 but sheet2 it could be row 100. So I need the macro to do a unique function to find the number in sheet2 and then compare each column, highlight differences in yellow. Columns will match up.

Step 2 is if the unique number is not in sheet2 highlight it in red.

Step 3 is to do the same as Step 2 but vica versa. Meaning if the unique number is in sheet2 but not in sheet1 then highlight in red.

Lastly Step 4 filter all columns that have a red or yellow cell.

Thanks