How do I colour fields in specific rows based on a value in another column?

[SandraStafverfeldt]

Hi,

If I have understood it correctly I need to add Render tool- if I want to achieve the same format/design in an Excel-output file corresponding to the table tool in Alteryx? But I am already struggling with getting the right conditional formula of colouring fields based on a value in defined column using Table tool.

E.g. if Column: [Check A-B]= "X" then fields in the same row but [Column A] & [Column B] should appear in the table with background color red.

Thanks in advance!

BR

Sandra

[atcodedog05]

Hi @SandraStafverfeldt 

Input data:

So here we will color column D and E based on column Check D-E

This how you do it. You need to add a Table tool like below.

In table tool config select the column one by one which needs to colored. In this case its column D and E.

Once you select column rule create gets enabled like below. Click on create

Set the rule to color D and E when Check D-E is X like below.

You need a Browse tool to view the temp output.

You need a render tool to output this formatted table to excel.

Like below.

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[SandraStafverfeldt]

Perfect- thanks a lot for the quick answer and solution!

[atcodedog05]

Happy to help 🙂 @SandraStafverfeldt 

PS please post the questions in Discussions channels or the main home page. So that people can help you and you will able to mark solution 🙂

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂

[atcodedog05]

Hi @SandraStafverfeldt 

The post as been moved to discussion channel.

Request you to mark the post as solution🙂

Happy to help 🙂

Cheers and Happy Analyzing 😀