Color my cells (conditional formating)

[Longdaica]

Hi all

After finishing my framework, I want to color my cell that in those condition

If Cell A1 <=80 = color green 

else if   100> cell A1 > 80 , color orange 

else Cell A1 color red

Table tool will format the every cells in a row which i don't want it.

Please help. 

[haroon_sa · Accepted solution]

Hey @Longdaica

I've attached my workflow with modified some configuration. Check out this!!

 

[PaulN]

Hi @Longdaica,

If I understand your current issue correctly, you may use a "column rule" over a "row rule".

Then you could achieve results like the following:

Thanks,

Paul Noirel

Sr Customer Support Engineer, Alteryx

[Longdaica]

Hello there

where is the colum rules ??

[haroon_sa · Accepted solution]

Hey @Longdaica

Here it is...

[melia001]

how can I have the same outcome but using something other than the table tool. As I need to export the outcome to excel and the table tool does not allow for this.

[PaulN]

Hi @melia001,

You will need to add a Render tool (https://help.alteryx.com/current/PortfolioComposerRender.htm) after the Table tool to export the result to Excel as in example below:

[melia001]

Hi Paul,

Thanks for your response. I have tried to do this but I keep getting an error when I render. I have attached a screenshot below. When I open the excel file it either gives broken data or missing completely from the columns. Any idea how this can be solved?

Thanks alot

[PaulN]

Hi @melia001,

Thanks for your message.

Could you please try to change the paper size (under section Report Style of the Render tool) for something bigger?

PaulN

[Sathishu1985]

Hi,

Good wishes. 

Please find the attached screenshot where I need to select the colored cells along with all the columns in the excel. Your immediate assistance would be much appreciated. 

Thanks 

Sathish

sumasha3@ford.com