conditional formatting in pivot table

S

shark102

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
 
R

Roger Govier

Hi

Assuming the PT is located in columns A through I
Mark columns B:I, Format>Conditional Formatting>Formula 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top