Style data using column rule

[Krish_Penubarthi]

Hi,

I have a requirement to color code a column based on value. 

Eg, input :

ID	sal
1	10000
2	15000
3	9500
4	12500
5	7500

I want my output to be like : ( red color when sal is less than 10000) 

ID	sal
1	10000
2	15000
3	9500
4	12500
5	7500

I am using 2019.4 version and I am not able to find column rules. When i use row rules entire row is changed to red.

How can this be achieved.

[RolandSchubert]

Hi @Krish_Penubarthi,

within the Table tool, select the column you want to format, then "Create Column Rules" is enabled:

In the next step, you can create the format you want:

Let me know if it works for you.

Best,

Roland

[grazitti_sapna · Accepted solution]

Hi @Krish_Penubarthi , use basic table tool  for this custom output.

1) Select Column Sal, then Edit Column Rules.

2) Under Apply choose When and select sal < 10000

3)Then select Text color Red.

Please refer to the image.

In order to output this format you can use render tool.

Thanks

[Krish_Penubarthi]

I am not able to see that option to select column rules in my designer tool.

Please refer to the attachment.

Version Used : 2019.4

[grazitti_sapna · Accepted solution]

@Krish_Penubarthi , please refer to the screenshot it is there I have highlighted it.

First you need to click on sal,only then it will be enabled and highlighted in blue.

Thanks.

[RolandSchubert · Accepted solution]

Hi @Krish_Penubarthi ,

just select the column "sal" in "Per Column Configuration", the option should be enabled then.

Best,

Roland

[Manjari]

Hi @grazitti_sapna , 

I followed the same steps, I get the color in the browse tool, when I export this to excel using the output tool I do not see the color coding of the Column . Am I missing anything?

[atcodedog05]

Hi @Manjari 

You need to use render tool to output with format.

[grazitti_sapna]

Hi @Manjari , as suggested by @atcodedog05  this works for render tool in normal output tool you might not be able to see the output as expected.

Thanks.

[Manjari]

Thank you @grazitti_sapna and @atcodedog05 for the quick response. 

I cannot see all the columns I expect out of the render tool. Is there any other way to get all the columns along with the color for 1 column too?