1 Reply Latest reply on Jun 9, 2016 5:29 PM by Ivan Young

    Conditional Formatting based on relationship to other values

    Ron Schultz

      I have a sample database that I hope someone can help with a solution.

       

      I have a survey score that I'd like to color code the "coins" in relation to what percentile ranking they fall into:

       

      All Stores 10% Percentile: The 10th percentile score of all DCS Stores (mean).

      All Stores 25% Percentile: The 25th percentile score of all DCS Stores (mean).

      All Stores 50% Percentile: The 50th percentile score of all DCS Stores (mean).

      All Stores 75% Percentile: The 75th percentile score of all DCS Stores (top quartile).

      All Stores 90% Percentile: The 90th percentile score of all DCS Stores (top decile).

       

      I have attached the sample file as well.

       

      Thanks

       

      Ron