I have used conditional formatting in order to highlight differences between two sheets. However this assumes that the two sheets have the exact same data in the exact same cells. Is there a way to make a comparison highlighting for true differences not just if cells are reordered between the two sheets.
Solved by M. C. in 18 mins