• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Ranking Conditional Formatting Pivot Table

Hi,

This has stumped me for a little while. I am needing to conditional format based on the Grand Total of the Pivot Table. It would be a top 5 negative or top 5 positive deal depending on if the Grand Total is negative or positive. Sample is attached with some notes inside.

Thanks for any help I can get.
 

Attachments

  • Chandoo Sample 10.5.20.xlsx
    14.3 KB · Views: 1
Back
Top