Hi Everyone,

I have a pivot table with 4 row labels and many columns in values. I have referenced cells back to the data in the pivot table so I can create formulas and build a report. (As shown below). However right now I am just showing "A". When I expand "a" by right clicking and hit expand field there are many sub items in "A" that total up to "A". I am trying to have conditional formatting so when it is only showing "A" under 1st column it shows the totals at the very bottom on letter "E" but when I expand the field I want to have conditional formatting on the total line of when all the sub items for "A" are expanded in column 2. Can you please help me with this conditional formatting formula.

Thanks


1 2 3 4 data data data data data data
a data data data data data data
b data data data data data data
c data data data data data data
d data data data data data data
e data data data data data data