Insert row and color code cells in excel

[PrashantJP]

Hi Everyone,

Could you please help me with adding a row and having it colored.

The input should look like below.

Sup Credit Officer	Not Past due	31-60	31-60	61+	Grand Total
Li,Ke Cheng	1	0	0	0	1
UNKNOWN	3	6	0	2	11
Yeung,Martin Tin Chi	151	84	10	3	248
Grand Total	155	90	10	5	260

The output should look like below

Thanks in advance!

Prashant

[mbarone]

you can't insert color into an excel cell.  you can insert data into a previously formatted excel cell.  in other words, if you have a spreadsheet with formatting in the cells, you can just drop data into the cells with the formatting preserved.  but you can't create the formatting in alteryx and drop it in excel.  however, you can create a report in alteryx and render that as an excel file and it will have formatting.

you'd have to use a Table Tool first where you'd do your formatting, and then a Render Tool with Excel as the output.

Attached is a simple example.  Check out the Column Rules on the Table Tool config.

[AZuc]

@PrashantJP see if this helps