Hello Experts, I have a new business case where I need to update the whole row data format change based on the value in one for the column cell. Could you please help me with some sample workflow about how to achieve this
Table tool is your solution. Workflow is included in this post: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Conditional-formatting-using-basic-table-tool/td-p/730769
Hey @akhukla, as mentioned by Alex, the Table tool can help with conditional formatting when working with Excel files. Below is a sample workflow for your reference.
@akhukla try the formula option in the row rule section, sample workflow attached
Hi, Both the solution offred are only updating the particular cell background colour which hold a specific data, but my requirement is to update the whole row from first column cell to last column cell wherever data is available in that row. the whole row should be highlighted with a specific colour
@akhukla all solutions provided are pointing to the same function in the same tool, but ultimately how it gets implemented logically is up to you. Not sure what the disconnect is for what you are still looking for
@akhukla any luck?