megera716
Board Regular
- Joined
- Jan 3, 2013
- Messages
- 140
- Office Version
- 365
- Platform
- Windows
I have a Pivot table in M2:O128. When the Pivot table fields are collapsed, I want to bold the cells on that row (which is the total of the rows beneath it) from columns P:V
My conditional formatting formula is =AND(ISBLANK($N3:$N128),ISNUMBER($O3:$O128)) and I've applied it to $P$3:$V$128.
When the Pivot table is collapsed, N is blank, but there are numbers in O, so I want the formatting. When I expand the field, the formatting in P:V goes away even though the conditions are still true -- N is still blank and O still contains a number (and my "applies to" range is big enough to cover the entire table when all fields are expanded)
My formula used to just be ISBLANK($N3:$N128) and it worked perfectly. But I added the ISNUMBER because the conditional formatting was applying to all the now-empty rows when the Pivot is fully collapsed and it was a little bit blinding.
What I'm getting:
What I want:
My conditional formatting formula is =AND(ISBLANK($N3:$N128),ISNUMBER($O3:$O128)) and I've applied it to $P$3:$V$128.
When the Pivot table is collapsed, N is blank, but there are numbers in O, so I want the formatting. When I expand the field, the formatting in P:V goes away even though the conditions are still true -- N is still blank and O still contains a number (and my "applies to" range is big enough to cover the entire table when all fields are expanded)
My formula used to just be ISBLANK($N3:$N128) and it worked perfectly. But I added the ISNUMBER because the conditional formatting was applying to all the now-empty rows when the Pivot is fully collapsed and it was a little bit blinding.
What I'm getting:
What I want: