How to colour specific cells

[Polite123]

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:

A	B	C	D
5	4	6	7
8	4	2	7

Thanks in advance

[grazitti_sapna]

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.

[Polite123]

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:)

[grazitti_sapna]

@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. 

Thanks.

[Polite123]

@grazitti_sapnaIt worked but I want to bold them as well(coloured values only):)

Thanks again:)

[grazitti_sapna]

@Polite123  under same column rule tab you will find Font option check the box and select B it will Bold the values.

If it helps kindly mark this post as solution.

Thanks.

[Qiu]

@Polite123 
Check the font box, and there is option for Bold and Italic

[rohit782192]

Thanks Sapna . It help even  me also. This is really a good explanation

[mutama]

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:

• https://www.youtube.com/watch?v=WUgw73BhlD8
• https://cndro.com/how-to-conditionally-format-an-excel-csv-file-in-alteryx/ 

Hope this helps!

[rohit782192]

Thanks you so much. It is Help ful.