Conditional Formating on a Pivot Table's GrandTotal

  • Thread starter Thread starter Jiby
  • Start date Start date
J

Jiby

Hello,
In the column "Grand Total" of my Pivot Table, I want all
the zero values to be highlighted in red.
I tried to select the column "Grand Total" and then define
a Conditional Formating. It works fine but... when this
column "Grand Total" moves from one column to another
(e.g. from column G to column H), due to new data, I loose
my Conditional Formating on the "Grand Total" because it
stays applied on the previous column G.
Thanks for your help,
-Jiby-
 
Hi

If your grand total is always on the same row, conditional format the whole
row. If the row changes as well as the column you could try something to
check for Grand Total in the relevant cell:
=AND(A3=0,A2="Grand Total")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing a pivot tables Grand Totals Column 1
Pivot table grand total location 1
How do I perform extended calculations in a Pivot Table in Excel 2 4
I can't see Grand total rows even though the option's switched on 2
Pivot Table Column Totals - XL2003 5
Grand Total for Rows not Working in a Pivot Table 1
Pivot Table Calculates the Difference in Grand Total 2
Pivot Table - 3

Back
Top