Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.
alteryx Community

# General Discussions

Discuss any topics that are not product-specific here.
SOLVED

## Color cell background

8 - Asteroid

Hi All,

How can I change the color of a cell background if there is 2 or more color set in a row ?.

8 REPLIES 8
17 - Castor

Hey @arjundelara, do you mean like this?

If so, you just need to set rules for each of the columns. As you can see here, I have applied the same rule to both. However, as they are different columns, the different colours used apply because of the column rules rather than using row rules:

8 - Asteroid

Hi @DataNath , Yes exactly if there's 2 or more color in a row it will change to another color. for example the cell that colored in yellow and green it will change to orange.

17 - Castor

Thanks for clarifying @arjundelara. What are your conditions for colouring? I'd imagine it'd be easier to set up 3 conditions within row rules instead. Also, if you could provide at least a small sample of data as well as expected outcome that'd be great to make sure I'm building the correct outcome!

8 - Asteroid

Thanks @DataNath

For the addition rules condition it will based on how many colored in a row.

As you can see the row 2 is colored in yellow and red so it meets the additional condition that it has 2 or more condition so it will colored to orange.

17 - Castor

How does this look?

Steps:

1) Set up your column rules as normal (i.e. Field] > 100

2) Set up a second column rule - in each column - that references all the other rules i.e. [Field] > 100 AND [Field2] > 100 - Assign the group colour to this (in your case orange)

This will tell Alteryx: If rule 1 (the individual) is satisfied, then highlight in a certain colour e.g. green/yellow. If the second rule is satisfied (i.e. other columns meet their conditions and will be coloured), highlight in another colour e.g. orange that you will use for them all.

8 - Asteroid

Thank you for the idea.

Highly Appreciated.

17 - Castor

No problem @arjundelara - you could also use a row rule which overrides column rules but then you’d highlight everything in the row (not sure if you want all cells coloured).

if this solves your issue then feel free to mark the solution or shout up and we can help some more!

6 - Meteoroid

Hi All,

Can any one help me how to change my O/P file's header background Color?

Labels