Share via

Row conditional formatting broken when filtering pivot table

Anonymous
2022-10-13T10:59:41+00:00

Hi all,

I have a pivot table in which I have conditional formatting rules applied to each row e.g. If the % difference is less than 10% show the whole row in blue, if the % difference is between -10% and 10% show the whole row in green. I set these rules to be applied to the ranges shown below:

If I filter the pivot table the conditional formatting gets removed from certain columns and the "Applies to" range automatically gets changed to the values shown below:

Any ideas how I can keep the conditional formatting applied to all rows/columns originally specific even when filtering the pivot table?

A dummy copy of the workbook can be found here.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

12 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-11-03T12:05:39+00:00

    Hi Waqas,

    Unfortunately my IT department said they are unable to try this step due to IT policy constraints. Is there anything else we can try to resolve the problem?

    Kind regards,

    Jenni Copple

    0 comments
  2. Anonymous
    2022-11-03T22:17:38+00:00

    Hi Jenni Copple,

    Thanks for your valuable feedback and sharing updates with us and I really appreciate your effort and your precious time doing. 

    And I appreciate your kind words.

    If possible, could you please allow me some time and I try to find another way to check and updates you here.

    Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

    Sincerely,

    Waqas Muhammad

    0 comments