colour the cell with different colours

Hi folks,

I have a data of few columns, and last column is the total -- in my output excel , i would like to colour the cells of this column with different colours like

for the cells having values between 0 to 5 as red,

cells having values more than 25 as green and all other cell as pink.

I tried using basic tool but no luck .. may be i am not doing something correct -- please help me with this.

Also if this formatting is done . how we output the data?

Thanks in advance

Datasets

Developer Tools

Common Use Cases

Accepted answers

afv2688

Hello @Ekta,

On the table tool click on Edit. There you will see the rules that I did apply. Select the one you want to modify and change the Formula as you wish.

Cheers

All comments

afv2688

You have to use the reporting tools, in your case, the table tool.

After, you click on the bottom on 'Edit row rules' and apply the ones you wish. In this example, I added the rule to change the text color to blue if the sales were more than 450000

Cheers

CharlieS

When you say "basic tool", do you mean the Output tool? If so, that tool is not capable of producing the output you desire. The Table tool (in the Reporting tool category) will allow you to apply custom formatting styles to your data, then the Render tool will allow that custom table to be produced in an Excel (.xlsx) format.