conditional formating in Excel 2007

[marinica]

Hi,
I created a pivot table, then I wanted to highlight the cells having the values between certain values, using conditional formatting.
Everything went fine, until filtering the data by rows, the formatting dissapeared.

Can anyone help me to fix this issue?

Thank you

 

[Trevor G]

See if this helps

http://www.mrexcel.com/archive/Pivot/20162.html

 

[marinica]

Hi Trevor G,

The issue I have is in 2007, it is not happening in earlier version of Excel.

And I don't change the columns from Pivot table as in the example you provided, just filtered it. Unfortunately, I can not post a screenshot to show you.
When I select all data back, the formatting disapears.

Regards