Insert row and color code cells in excel
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
