Conditional formatting applied to a pivot table doesn't work as it should

[Pichingualas]

Hello everyone

I have a problem concerning conditional formatting and pivot tables.

After executing the following macro:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

on a sheet which contains a pivot table, it happens exactly what I want which is negatives get shaded. But if after that you expand any of the categorys within the pivot table, the selection to which the conditional format is applied changes and it no longer works, even when the categorys are closed again.

Can any of you think of a solution to this, so that the conditional format will be applied to all the cells of the pivot table, even when you expand or close each category?

Thanks in advance

[Pichingualas]

Anyone help please?

[OnErrorGoto0]

You need to apply the formatcondition to each data field individually and then set the format conditions scope using:

Please Login or Register  to view this content.

[Pichingualas]

I solved it, posting in case it helps anyone else:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

There it goes, hope it helps someone else.

[Pichingualas]

Tip for the future: if you don't give feedback, you won't get feedback.

Thanks but it turns out I didn't need it this time.