I am being asked to recreate a report that: * Transposes the rows and columns * Shows conditional formatting on all date cells: * If the cell date is before today is one color * If the cell date is after or equal to today then another color * If the cell contents is N/A or TBD then a third color * If the cell date is within 7 days of today then a fourth color I can create column rules for each column in the output, but the number of columns (and their names) may change with each running of the report. I tried putting the Status in between the Transpose and Cross Tab tools, but I did not know what to do with it. The workflow has a text input with sample data. Any help would be greatly appreciated! Conditional Formatting.yxmd

Conditional Formatting for variable number of columns

I am being asked to recreate a report that:

Transposes the rows and columns
Shows conditional formatting on all date cells:

If the cell date is before today is one color
If the cell date is after or equal to today then another color
If the cell contents is N/A or TBD then a third color
If the cell date is within 7 days of today then a fourth color

I can create column rules for each column in the output, but the number of columns (and their names) may change with each running of the report.

I tried putting the Status in between the Transpose and Cross Tab tools, but I did not know what to do with it.

The workflow has a text input with sample data.

Any help would be greatly appreciated!

Conditional Formatting.yxmd

Reporting

Accepted answers

Qiu

@Darrie8468
I am sorry I think I was mistaken. You have already said in the title.

I get hint from this post and made some modifications.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Conditional-Formatting-of-Dynamic-Columns/td-p/907261

0413-Darrie8468-r1.yxmd

All comments

gabrielvilella

If the number of columns keeps changing, you might be able to achieve this if you edit the RAW XML with a macro, but this won't be a simple task. Another idea is to have an Excel template that you just overwrite with new data, but the formatting is there already. In Alteryx, it is always recommended to work with your data in rows to avoid situations like this. Columns should be static and records dynamic.

Qiu

@Darrie8468

There is a detailed disucussion here on how to highlight cells in Table tool.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Color-my-cells-conditional-formating/td-p/162934

And I am sorry I was not able to fully understand the intended format here. so just my guess.
I also have modified your formula since the String Data can not be compared with a Date Format data.

0413-Darrie8468.yxmd

Qiu

@Darrie8468
I am sorry I think I was mistaken. You have already said in the title.

I get hint from this post and made some modifications.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Conditional-Formatting-of-Dynamic-Columns/td-p/907261

0413-Darrie8468-r1.yxmd

Darrie8468

That is EXACTLY what I needed to move me in the right direction.

Thank you!

Qiu

@Darrie8468
Thank you for the feedback and glad to be helpful. 😁

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167