2 Replies Latest reply on Apr 5, 2018 9:45 AM by Jim Dehner

    Dynamically Color Top Bars, Order Always Descending

    Marc Levy

      In the attached workbook, I'd always like to highlight the top 3 highest bars by percentage in green and the rest in dark grey.   I'd like this to be dynamic, so that if I change beverage from "Pepsi" to "Coke", the formatting adjusts accordingly. 

       

      Also, I want to be sure the bars are always in descending order.

       

      Appreciate it someone could provide an explanation on how to do this and provide a workbook with these solutions in place.

       

      Thanks.