Conditional formatting highlights cell-level differences, while Power Query reveals structural changes across entire datasets ...
I'm all for anything that makes Excel easier to use.