4 Replies Latest reply on Mar 16, 2017 3:50 AM by Christoffer Haaland

    Conditional Formatting

    Christoffer Haaland

      Hi lovely people of the inter web!

       

      I am currently building a CRM dashboard for our internal stakeholders to see their teams email performance which fancy scatter plots and what not. Now I've been asked to add a dashboard listing key stats with filled background based on performance. I've attached a screen shot of what I got so far.

       

      Does anyone know how I can add conditional formatting to these cells? E.g. Unique Open Rates across the enterprise is 22%, if any of the Unique Open Rates cells have a higher % I want the cell to be filled with green. Every cell under, filled with red. etc. Unique CTR will have different averages, so I need to have different range for different columns.

       

      Would appreciate any thoughts and ideas.

       

      Thanks,

       

      Chris

       

      Screen Shot 2017-03-13 at 14.35.34.jpg