Hello !

Is there a way to conditionally format pivot table ???

What I have is the pivot table with few main dimensions and each of those
has 2 subdimensions - I need to have all values in subdimension 'NP' in red -
and corresponding row header - that would be great
I'll draw a rough sketch below so there is less confusion



region
west east north south
p np p np p np p np

customer
a
b
c
d
etc....

so I need customer name and value in column 'np' in red for all rows where
column 'np' is not blank. This would be no problem in regular table, i used
conditional formatting in source tab for this pivot but it does not help (it
works only in source data)

any suggestions greatly appreciated