Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Table: highlight values within range or at certain positions

UnknownUser
7 - Meteor

Hi,

 

I want to highlight (= change text color) elements within my table:

 

1. I want to highlight values within a certain range, i.e. between 30 and 50

2. I want to highlight certain "positions" within a table, i.e. 2nd column, 3rd row

 

Is this possibile within Alteryx? 

 

Best

Felix

2 REPLIES 2
DavidP
17 - Castor
17 - Castor

Hi Felix,

 

You can do this by defining Column rules in the Table tool. I'll have a play to mock up an example for your.

DavidP
17 - Castor
17 - Castor

The attached example workflow shows how the 2 scenarios can be implemented.

 

conditional colour.png

 

Also look at this post for rules regarding sequencing of multiple rules: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Cells-color/m-p/351000#M64160

Labels
Top Solution Authors