Conditional formatting for null values in pivot view

Question

HI,

i am having issue in pivot view with conditional formatting for null values.

i have values like below In pivot view.

A  100

B

C   200

I Want to apply conditional formatting(total row to bold) for row B Even though corresponding value is null.

anyone suggest me how can i get this?

user12863665 · Answer

Hi, i have data like below print screen.

First column is Customer Name and Second Column is Revenue.

Im my report i display 20 static customer names even though their values are null. for couple of customers i apply conditional formatting like if Customer Name is 'Adah Bacon' then display as Bold.

i apply this conditional formatting for Customer Name and revenue columns.But here the issue is if the 'Adah Bacon' revenue is null then none of the rows showing in bold color(i mean Adah Bacon in first column also not showing in bold).

Can you suggest me any work around to get this fixed?

Gianni Ceresa · Answer

I'm not really sure of what you really try to do as it works ...

Conditional formatting on the Revenue column with condition Customer Name = "Adalia Abbey" and style BOLD (and background to make it more visible).

Null cells, as said earlier, aren't impacted but the other cells on the row adopt the style.

So can you maybe post a screenshot of what you have and where you don't have your conditional formatting working?

user12863665 · Answer

anyone suggest me if any work around for column formatting for null values?