Conditional Formatting for Data Table

[Fabian_Cybulla]

Dear Alteryx community,

I'm looking for a way to create a conditional formatting in Alteryx. Something that is easily done in excel and I can't find a way to do it in Alteryx.

My sample Dataset looks like this:

	01.10.2023	02.10.2023	03.10.2023	04.10.2023	05.10.2023	06.10.2023	07.10.2023
01.10.2023	0%	0%	0%	0%	0%	0%	0%
02.10.2023	38%	44%	0%	0%	0%	0%	0%
03.10.2023	95%	73%	66%	0%	0%	0%	0%
04.10.2023	100%	100%	100%	35%	86%	0%	0%
05.10.2023	100%	100%	100%	50%	86%	86%	0%
06.10.2023	100%	100%	100%	79%	90%	89%	89%
07.10.2023	100%	100%	100%	79%	100%	100%	100%
08.10.2023	100%	100%	100%	100%	100%	100%	100%

And it should look like this:

The Dataset is a daily growing Dataset. So I need a way where I don't need to define the columns in the formula, if possible.

Thank you all for the help in advance!

[binuacs · Accepted solution]

@Fabian_Cybulla you need to define all the column rules in the table tool for the numbers 

[Fabian_Cybulla]

Thank you for the reply! I was hoping for an easier solution. But I'll mark it as solved.

[CoG]

One way to simplify the building of this solution is to first attach the table to a dummy text input with just a Date column, then add the rules to the "Dynamic or Unknown Fields", then delete connection to dummy data and reconnect to main input table.

All rules will then be added automatically to new columns, which are just your original columns anyway!