Conditional Text Formatting on Pivot Table

[#1]

I'm trying to do a conditional formatting on a Pivot Table where one of the dimensions is the Months.  I'd like to have the past months to be in bold font.  Somehow, it's partly doing it with this:

if(Month(EffectiveDate) < Month(Today()), '<b>'))

It works partly because in some selections, some (yes, just some) of the past months is not showing as bold.  Not sure what I'm missing.

Please help!  I'm a newbie!

[#2]

no difference.  still the same.

[maxgro]

and if you add 2 expressions

max(Month(EffectiveDate))

Month(Today())

what do you get for Mar, Apr?

[#4]

10 and 11 for March and April, respectively.

[#5]

Attached is an example of what I'm trying to do.  the 'C' should be bold based on the conditional formatting I gave but since Q1 is zero for C, the Dimension is not showing bold.

[gmoraleswit · Accepted solution]

You can have zeros instead of nulls, it seams like  this solves the problem (see attached)

[#7]

It works. Thank you.  However, some of my Pivot Tables turn to all zeros after I un-select the 'Suppress Zero-Values'.  I'll research on that next.  Let me know if you know the answer to that as well.

Thank you.

[#8]

Is there another way of accomplishing this.  I have fields that are all zeros and I want to hide them.

[gmoraleswit]

I couldn't find a nice way to do it, but what you can do is add another expression that populates the cells with 'ones' only for the first value/row (in case its always the same or you can calculate it someway)

See attachment