Color cell background

[arjundelara]

Hi All,

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

[DataNath]

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:

[arjundelara]

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.

[DataNath]

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!

[arjundelara]

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.

[DataNath]

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.

[arjundelara]

Hi @DataNath

Thank you for the idea.

Highly Appreciated.

[DataNath · Accepted solution]

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!

[Jayapriya]

Hi All,

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