Change row color

Question

Hi all,

I wanna change row color depend on the due date. If the due date is today then the whole rows data with today due date will be changed to red and if the due date is tomorrow then the whole rows with tomorrow date will be change to green.

I tried by using Table tool but unfortunately I didn't get the desired result.

RowColor.PNG

AngelosPachis · Accepted Answer

Hi @masfouaa ,

Here's how I did it. I used a formula tool to first convert the Due Date field in a format that alteryx understands as a date. Then I created a new column that checks if that date is today or tomorrow

Finally, in the table tool, I created two row rules to colour each row based on the values in the [Colour] column created before and dropped the columns I don't need anymore

Here's the output I got

Hope that helps,

Angelos