10 Replies Latest reply on Dec 10, 2018 5:48 AM by sameera.pathirannehelage.0

# Color cells of a tableau pivot table according to a condition - Conditional formatting in Tableau

Hi All,

I wanted to highlight the cell of Rate Per 10000 by comparing the figures of P11 and RSC. If RSC shows a higher rate than P11 then I want to colour the cell of P11 Rate Per 10000 in Red else Blue.

Would this be possible in Tableau?

• ###### 1. Re: Color cells of a tableau pivot table according to a condition - Conditional formatting in Tableau

Hi, Sameera

Below is the end result for your reference.

Hope this helps

ZZ

1 of 1 people found this helpful
• ###### 2. Re: Color cells of a tableau pivot table according to a condition - Conditional formatting in Tableau

Hi ZZ, Thank you so much. This is exactly what I wanted. Thanks again. Much appreciated.

BW
Sameera

ZZ

• ###### 4. Re: Color cells of a tableau pivot table according to a condition - Conditional formatting in Tableau

Hi ZZ,

Is this solution can be created in Tableau 2018.2 version?

BW

Sameera

• ###### 5. Re: Color cells of a tableau pivot table according to a condition - Conditional formatting in Tableau

Yep

ZZ

• ###### 6. Re: Color cells of a tableau pivot table according to a condition - Conditional formatting in Tableau

The Calculation1 did not produce the blue cells. What can I do to fix this?

• ###### 7. Re: Color cells of a tableau pivot table according to a condition - Conditional formatting in Tableau

can you attached the sample workbook?

ZZ

• ###### 8. Re: Color cells of a tableau pivot table according to a condition - Conditional formatting in Tableau

Hi ZZ,

I hope you are well.

Previously you have produced a chart with Red and Blue color combinations looking at the rates.

Red If RSC Rate Per 10000 is higher than the P111 Rate per 10000 else blue.

Is it possible to switch these colours other way round only for 'Unspecified' category?

Because only in Unspecified category higher the rate than RSC is bad(Red) and low is blue.

Please find attached the workbook for this.

I hope you could help me with this. Many thanks in advance.

Kind Regards,

Sameera

• ###### 9. Re: Color cells of a tableau pivot table according to a condition - Conditional formatting in Tableau

Hi, Sameera

thx.

Hope this helps and let me know if any question

ZZ

1 of 1 people found this helpful
• ###### 10. Re: Color cells of a tableau pivot table according to a condition - Conditional formatting in Tableau

Many thanks, ZZ..

This is great!!

Kind Regards,

Sameera