VBA CODE to track the changes : I Need a VBA code which can track the changes with OLD sheet & NEW sheet with the values not by Cells,we have a Unique value which will be same in both sheets is in "Z"column.If any new no.will be found, it should Highlight as a new Order No.[This is the sheet screenshot in that Z column contains the Unique no.with which i tried to compare with old sheet,but i failed.][1]


  [1]: https://i.stack.imgur.com/wdXvA.png

Please Help me with this.I will be very thankful for this.....