Color coded column upon condition

I have a task wherein I am doing some data transformation, Before I send this output to the user I want to highlight few column based on some condition.

I want to make few columns red where the value is empty, not necessarily all the empty columns.

Please help me if you can on this. attaching a sample file for your reference.

Operation_LoadSheet.xlsx

Reporting

Tips and Tricks

Transformation

Accepted answers

kelvin_law1

Yes, you can add condition. Here is how you can do it:

1. Select the column that you want to add the condition and press the Column Rules Edit button:

2. The following windows will prompt for your condition setting:

Condition setting.png

3. After running the workflow, the output table object (view with Browse tool) will be like the below where Region cells are highlighted in red when Total Sales > 200,000:

All comments

kelvin_law1

Hi @ajanayak

You can try exploring the Table tool under Reporting which you can create Row or Column rules to change the background color.

To output this table object in Excel, you will need to put the Render tool (not Output Data tool) behind the Table tool.

ajanayak

The question is can we add condition there? not sure, any demo example you have.

ajanayak

It worked, Thanks for all your help.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703