Create a macro in excel 2016 to compare 2 workbooks and highlights differences

On excel 2016- I have a macro set up already to compare two files and highlights differences in different ways depending on differences .i would like to have it reviewed and corrected as it is still not 100% behaving as expected.. What is expected is as follows : 1-colour tab in red if it’s worksheet is modified 2-highlight in yellow if an existing row’s values were changed and put in bold the changed values 3- highlight in blue a new added row and put all new values in bold 4-If a row was deleted from the original file then add it in grey to the modified file at the end of the last row in that file. 5-If values deleted from cells , highlight row in yellow as in 2 above AND put back the value in grey in its cell to see it What needs done in this request: 1- review the macro and make sure it behaves as expected and fix bugs I am sending the macro file along with the one to be tested .