How to compare excel sheets

alorchi Posts 1 Registration date Tuesday September 26, 2017 Status Member Last seen September 26, 2017 - Updated on Oct 9, 2017 at 06:00 AM


I'm stopping by to know if any one could help me to compare between to sheets in excel with some conditions.

Like it finds something missed from one of them it would marked by yellow color.
and If it finds something new it would be marked by red color.
If it finds something edited it would be marked by blue color.
If there's nothing different it would keep it in white color

Nota : in our sheets we will have the name of the files of DWG with their system date so something we could have the same name in of the file in both of sheets but not at the same place so it would be compared by the names and date of the file like the attached file.