Hi, I have a requirement to color code a column based on value. Eg, input : IDsal1100002150003950041250057500 I want my output to be like : ( red color when sal is less than 10000) IDsal1100002150003950041250057500 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.

Style data using column rule

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.

Reporting

Preparation

Expression

Accepted answers

grazitti_sapna

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

Style-GS.yxmd

grazitti_sapna

@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

Hi @Krish_Penubarthi ,

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

Best,

Roland

All comments

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

Column.yxmd

grazitti_sapna

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

Style-GS.yxmd

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

table tool.jpg

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703