Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
RÉSOLU

Color my cells (conditional formating)

Longdaica
Météore

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. 

14 RÉPONSES 14
haroon_sa
Boule de feu

Hey @Longdaica

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

formatting.PNGformating.png 

PaulN
Alteryx Alumni (Retired)

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

 

 

Longdaica
Météore

Hello there

 

where is the colum rules ??

haroon_sa
Boule de feu

Hey @Longdaica

 

Here it is...

Column_rules.png

melia001
Météoroïde

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
Alteryx Alumni (Retired)

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

 

melia001
Météoroïde

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
Alteryx Alumni (Retired)

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
Atome

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

 

 

Étiquettes
Auteurs des meilleures solutions