Pivot Table: format rows based on a column value

Robie
5StarLounger
Posts: 656
Joined: 18 Feb 2010, 14:26

Pivot Table: format rows based on a column value

Post by Robie »

Hi

I think the answer is *NO* but I will ask anyway. Is it possible to format (colour) individual rows based on a column value in a Pivot Table?

For example, if column 5 is 'Yes' then set the pivot table row as Black on Green otherwise Blank on Red.

Thanks.
Robie

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Pivot Table: format rows based on a column value

Post by Rudi »

You could attempt conditional formatting directly on the pivot table (if the structure does not change much)
See sample.

I have not tested thoroughly to see if the dynamics of the table will alter the CF...
Book1.xlsx
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

Robie
5StarLounger
Posts: 656
Joined: 18 Feb 2010, 14:26

Re: Pivot Table: format rows based on a column value

Post by Robie »

Rudi wrote:You could attempt conditional formatting directly on the pivot table (if the structure does not change much)
See sample.

I have not tested thoroughly to see if the dynamics of the table will alter the CF...
Book1.xlsx
That is most excellent Rudi. I managed to use conditional formatting and it works.

As regards to the dynamics of the table, I created the formatting when the table is at its largest possible values (several hundred rows). It seems to handle smaller size tables.

Thank you very much. :cheers: :clapping: