5 Replies Latest reply on Aug 14, 2018 5:19 PM by Shinichiro Murakami

    Conditional formatting for Quartiles

    Jyosthna

      Hi,

       

      I am trying to implement the conditional formatting based on the quartiles. So the percentile calculation is based on the payment field. So when i keep it under the conditional formatting, all the columns in the same row has different colors. But ideally all the columns in one particular row should have the same color and should come under the same quartile. I have attached the test workbook.

       

       

      Thanks in advance.