Hi,
Need help for quick analysis of below data.
Need to fill colour in specific cells
I want 5 and 2 in below to have yellow background
Something like this:
Thanks in advance
Hi @Polite123 , do you have any specific condition for coloring the background or it is just for these values in the particular column?
I have prepared a mock workflow. Please let me know in case of any queries.
Thanks.
Hi @grazitti_sapna,
There are no specific conditions. I just want to highlight any cell in the output sheet.
How can we do that?
It was just for example I had given those values(5&2).
Can you please help?
When I am doing so with the help of render tool,it colours that entire row which is not needed
Thanks in advance:)
@Polite123 , Sure.
1) You need to add basic table tool to the input file.
2) Select the Column where the value lies then select column rule edit option. A pop dialog box will open then select A rule 1 and apply the config mentioned in the screenshot.
This will color the background of the value you specifically want.
I hope this helps.
@grazitti_sapnaIt worked but I want to bold them as well(coloured values only):)
Thanks again:)
Hi @rohit782192 , additionally you can also refer to this Tool Mastery Guide on the Table Tool here to further guide you in this use case: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Table/ta-p/49555
Quite a comprehensive explanation and step-by-step guide. Other useful resources include the following video tutorial guide:
Hope this helps!
Thanks you so much. It is Help ful.
How to output the color formatted table i to excel?
Hi @grazitti_sapna - is there a way to do this for dynamically changing column names?
