1

Topic: Conditional formatting on the pivot table

Hello!
On the pivot table a macro I will interpose conditional formatting. But why conditional formatting works as that strange. Does not fill value 2. What here not so?

2

Re: Conditional formatting on the pivot table

3

Re: Conditional formatting on the pivot table

ferzmikk wrote:

does not fill value 2

More truly does not make out a cell with value 2, and continues to make out cells with value 1.

4

Re: Conditional formatting on the pivot table

Method Add strange works
Why so?

5

Re: Conditional formatting on the pivot table

It was in MicrosoftOffice2007. And in 2013 versions normally works.

6

Re: Conditional formatting on the pivot table

ferzmikk wrote:

It was in MicrosoftOffice2007. And in 2013 versions normally works.

It about indexes

7

Re: Conditional formatting on the pivot table

Altered. But not up to the end it turns out in 2007 versions as it is necessary. And in 2013 - works completely. Really to make so that in 2007 versions worked completely? In a nested file in the code the comment in that place where does not work in 2007 versions is specified.