Highlight cells in output

Question

I have a data set given as below. I have to compare values in column P with new P,  Q with new Q and R with new R.

PQRnew  Pnew Qnew R210.1210.152-0.55-2-2644066406-6-256+6253+4103+410

And where there is change in values, I have to highlight those values.

PQRnew  Pnew Qnew R210.1210.152-0.55-2-2644066406-6-256+6253+4103+410

I have to get this output in excel as well as layout tool

DataNath · Accepted Answer

Hey @PB41091, how does this look? For the 3 fields we just need to set up column rules to check whether p/q/r != new p/q/r and if this is true, colour the text red:

Outcome gets you:

To output to an Excel when using reporting tools, we just need to stick a Render tool on the end and choose Excel: