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