conditional formatting in pivot table
 

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

conditional formatting in pivot table
 

Hi

Assuming the PT is located in columns A through I
Mark columns B:I, FormatConditional FormattingFormula is
=MOD(COLUMN(B:I),3)=0)
Mark column A Formula is =
ISNUMBER(SUMPRODUCT((MOD(COLUMN(B:I),3)=0)*(B:I)))

Set format to Red in both cases.
--
Regards

Roger Govier


"shark102" wrote in message
...
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