Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Highlight cells in output

PB41091
8 - Asteroid

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 R
210.1210.1
52-0.55-2-2
64406640
6-6-256+625
3+4103+410

 

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

 

PQRnew  Pnew Qnew R
210.1210.1
52-0.55-2-2
64406640
6-6-256+625
3+4103+410

 

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

2 REPLIES 2
DataNath
17 - Castor
17 - Castor

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:

 

DataNath_0-1667384606515.png

 

Outcome gets you:

 

DataNath_1-1667384616895.png

 

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

 

DataNath_2-1667384763972.pngDataNath_3-1667384774375.png

grazitti_sapna
17 - Castor

@PB41091 , You can easily achieve this using table tool and applying column rule by selecting columns and adding the condition as below:

 

grazitti_sapna_0-1667386792030.png

 

Sapna Gupta
Labels
Top Solution Authors