This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Here is one approach. You'll need a field that identifies each row as unique (Row ID tool here), and then Transpose. A Multi-Row formula tool, grouping on the Row ID field, and looking to tag rows with null values but having a number below them with a Y. Others are tagged with an N.
A Summarize builds a tagging field that combines all of the Ys (and Ns) generated by the Multi Row tool, and that's joined back in.
Then you'll need a table tool to add the highlights (Alteryx doesn't really format your data unless you render it into a table). I used a Row rule, that adds a red fill to the row if the tagging field contains a Y.