ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Complex row formula for table tool

6 - Meteoroid

Dear Alteryx community,


I am looking for a solution for the following:


I want to highlight specific cells in a specific row, if the values in these cells are the same as the values in another specific row.

To explain a bit more what I need I tried to create the following visualisation:





So, if in column A, a row contains 6, than I want to match the values of that row to the values included in for example row 3. If these match, than I want to highlight that specific cell.


Can someone please help me to translate this into a formula that I can use as "row rule" in the table tool?


thank you very much!


kind regards,




17 - Castor
17 - Castor

Hi @Julianus 


Applying colors to duplicate values is possible, but we need to do some work before the Table tool. The problem is that the Table tool doesn't have the multi-row functionality so we'll need to prepare that ahead of time. 


I put together an example that identifies duplicate values in [Column C] and will apply a unique color to each value. It work by assigning a color and joining a style expression to those rows that the Table tool can then use.




Check out the attached example and let me know if you have any questions. 

6 - Meteoroid

Hi CharlieS,


thanks for the input! I actually only want to highlight the cell B, not the entire row.


In the meanwhile I thought of another way to solve this. It is perhaps not the most efficient but I combined

some filter, formula and multi-row tools to achieve the same results.


Thanks for the help!


kind regards,