Conditional Formating on a Pivot Table's GrandTotal

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-
 
G

Guest

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")
 
Top