This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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: