community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Color my cells (conditional formating)

Meteor

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. 

Alteryx Certified Partner

Hey @Longdaica

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

formatting.PNGformating.png 

Moderator
Moderator

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:

 

Table_example.png

 

 

Thanks,

 

Paul Noirel

Sr Customer Support Engineer, Alteryx

 

 

Meteor

Hello there

 

where is the colum rules ??

Highlighted
Alteryx Certified Partner

Hey @Longdaica

 

Here it is...

Column_rules.png

Meteoroid

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.

Moderator
Moderator

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:

 

AlteryxGui_2019-04-13_18-22-17.png

 

Meteoroid

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

Moderator
Moderator

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

 

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

 

 

Labels