TOP FUNCTION highlight top three values from selected range but with same color for top three.i want different color for all three values means golden color for 1st highest, silver color for 2nd highest and yellow color for 3rd .
i have values in c31 to c41 in percentage in first column and E31 to E41 in percentage in second column.want to select highest values from both columns comparing simultaneously?
i have values in c31 to c41 in percentage in first column and E31 to E41 in percentage in second column.want to select highest values from both columns comparing simultaneously?