Conditional formatting

[jamesd]

I have a pivot table with 10 collumns and approx 1500 rows .
When I apply conditial formatting to ,say the top 10 rows all is fine but when I try to format the whole table nothing happens.

Why does the conditial formatting not work over a larger selection ?

What am I doing wrong.

 

[GNB]

How are you doing your conditional formatting? If you highlight the column in a pivot it should work fine regardless of fliters etc.

If you just highlight the top 10 if filtered and do this then it wont work