Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Color my cells (conditional formating)

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

14 REPLIES 14
haroon_sa
10 - Fireball

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
7 - Meteor

Hello there

 

where is the colum rules ??

haroon_sa
10 - Fireball

Hey @Longdaica

 

Here it is...

Column_rules.png

melia001
6 - 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.

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
6 - 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

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
5 - Atom

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