How to compare excel sheets

Closed
Posts
1
Registration date
Tuesday September 26, 2017
Status
Member
Last seen
September 26, 2017
-
Hello,

Hi

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.