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.
P | Q | R | new P | new Q | new R |
2 | 1 | 0.1 | 2 | 1 | 0.1 |
5 | 2- | 0.5 | 5- | 2- | 2 |
6 | 4 | 40 | 6 | 6 | 40 |
6- | 6- | 25 | 6+ | 6 | 25 |
3+ | 4 | 10 | 3+ | 4 | 10 |
And where there is change in values, I have to highlight those values.
P | Q | R | new P | new Q | new R |
2 | 1 | 0.1 | 2 | 1 | 0.1 |
5 | 2- | 0.5 | 5- | 2- | 2 |
6 | 4 | 40 | 6 | 6 | 40 |
6- | 6- | 25 | 6+ | 6 | 25 |
3+ | 4 | 10 | 3+ | 4 | 10 |
I have to get this output in excel as well as layout tool
Solved! Go to Solution.
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:
@PB41091 , You can easily achieve this using table tool and applying column rule by selecting columns and adding the condition as below: