Change the color of the fields on data table

[Sshasnk]

I have attached the file here, I basically have to change the color of the field based on where the header is starting from

Please look into the input sheet and let me know if you have any questions

[FilipR]

You cannot use Alteryx to change cell colors in the Excel reports it produces.

You can work around it by making a template with conditional formatting, and populating it instead of creating new Excel files.

[Sshasnk]

@FilipR Yes, I am asking for the second part. I am not sure how to do the formatting in table tool and I know we can do that and create report using render tool

[MilindG]

Not sure if thats what you're looking for

[Christina_H]

You need column rules in the table tool.  You can set the rule to always apply on that column or based on a condition.

[binuacs]

@Sshasnk One way of doing this with the table tool using the column rules and row rules

[FilipR]

Use these settings in the Output Data tool:

Note that you have to define your range upfront. You can write a bigger number than the number of rows you expect to be written into the table, or think about a more dynamic solution.

Please see a working example attached.

[Sshasnk]

@binuacs How you added the yellow color

[binuacs]

@Sshasnk you can add column rules