Color coding in table with range

[Lakshmikanth_2021]

I have the list of data with percentages. I need to color the text with given criteria. 

0 - Red

1-29 - Grey

30 - 69 Amber

0-100 Green

I need to have this color coding to numbers in Table. 

[ShankerV]

Below, I outlined the steps you can follow to build your own solution workflow.

Why should you try to build it yourself?

[1. It reduces professional risk] You might be tempted to copy a provided solution workflow. If you implement it without learning and understanding proper use, you risk it failing and being unable to fix it.

[2. You will increase personal proficiency] If you invest in understanding the concepts and build the solution yourself, you will be able to build workflow solutions better and more efficiently in the future.  

Build your own solution guide

1. Input your data with Column you want to process

2. Use the Basic Table tool, to derive the output.

Click on Percentages column in Per column configuration

Click on Column Rules -> Create

Click on the Formula box and use the below formula.

[Percentages]>=70 AND [Percentages]<=100

Select the Background color based on the formula.

3. Use the Browse tool to check the output after Run.

We encourage you to try it yourself. Refer to the below section only if you are stuck

Spoiler

Kudos to you! If you were able to build the solution yourself :)

Please share with us if you were able to successfully build it or if you are facing any issues.

Happy to help :)

You can learn more about how to use Table tool to build your own solution with the help of examples availble within Alteryx Designer.

Many thanks

Shanker V