Google Sheets Custom Color for top 10 values when values are not sorted and contain formulas
<p>I'm having a problem getting Google Sheets to color the top 10 values in multiple columns. </p>

<p>I have columns that contain the following stock information:</p>

<p>Account,Ticker,Symbol,YTD,1 Yr,5 Yr,10 Yr,Risk,Return,Star Rating</p>

<p>Example:
T. Rowe Price U.S. Large-Cap Core Fund,TRULX,2.2,3.93,12.3,12.67,2,5,5</p>

<p>I would like to color the top 10 values for the 1 Yr, 5 Yr, 10 Yr columns.  </p>

<p>I thought the function large(L:L,10) would do the job but it seems that the function needs to be sorted by the field that its coloring and it doesn't seem to work if the values in the column are formulas.  All the data in these fields but the ticker are formulas.</p>