title: How to highlight 1st, 2nd and 3rd highest from two column
body: <p>I tried by selecting range then conditional formatting then cell value equal to then =large($C:$E,1) THEN fill golden color for 1st highest value. This formula applies to entire columns. I need help with applying formula within range i.e from  31 t0 41. I have values in column C i.e c31:c41 and column E i.e E31:E41 in percentage . I want golden color for 1st ,silver for 2nd and yellow for 3rd highest of two columns. Column D has names so column D can not be selected.</p>
  
  <p><a href="https://i.stack.imgur.com/WWLDL.png" rel="nofollow noreferrer">SAMPLE EXCEL FILE</a></p>
  
  <p><em>sample data</em></p>
  
  <pre><code> C              D           E
   2.54%        vinu          5.69%
   119.90%       anand        157.34%
   49.32%       tanaji         7.39%
   82.28%       umesh        121.21%
  -21.66%       chandu        94.10%
  -60.45%       rajan        -25.71%
  -20.12%       mule          37.02%
  -16.05%       jafgtap       31.085%
  -3.50%       kunal         282.62%
  -3.27%       ramesh         14.58%       
  -8.12%       rajesh          5.86%
  </code></pre>