Hi,
I designed a pivot table and have the datas in percentage. So for each row, I have to highlight top 3 values (highest by individual row level) in different colors. Can someone help me with it?
<tbody>
</tbody>
Take for example this sample table. For sub 1, the highest values are MARK1, MARK4 and MARK2
I want only these cells to be highlighted. Similarly for SUB2, SUB3 and so on.
I will be very much happy if it can be done in different colors
I designed a pivot table and have the datas in percentage. So for each row, I have to highlight top 3 values (highest by individual row level) in different colors. Can someone help me with it?
SUBJECT | MARK1 | MARK2 | MARK3 | MARK4 |
SUB1 | 86 | 67 | 12 | 76 |
SUB2 | 45 | 56 | 35 | 97 |
SUB3 | 49 | 34 | 13 | 94 |
SUB4 | 46 | 78 | 73 | 95 |
SUB5 | 94 | 39 | 23 | 94 |
<tbody>
</tbody>
Take for example this sample table. For sub 1, the highest values are MARK1, MARK4 and MARK2
I want only these cells to be highlighted. Similarly for SUB2, SUB3 and so on.
I will be very much happy if it can be done in different colors