Hello all,
Requesting help from you guys. So basically I am doing a tool comparison and my final dashboard looks like below
<tbody>
</tbody>
So what I am thinking is a way to highlight in which categories is Tool 1 better/worse than the other tools.
Is there any macro/formula which takes the first value of Tool 1(8), and compares with the other tool values(4 & 3), if it is the largest value - highlights it green, if lowest value highlights it Red, if neither than remains as it is. This logic loops through all the values in Tool 1 column.
Appreciate any help/tips. Thanks for your time.
Requesting help from you guys. So basically I am doing a tool comparison and my final dashboard looks like below
Evalution category | Tool 1 | Tool 2 | Tool 3 |
ABC | 8 | 4 | 3 |
DEF | 1 | 3 | 6 |
XYZ | 5 | 2 | 5 |
<tbody>
</tbody>
So what I am thinking is a way to highlight in which categories is Tool 1 better/worse than the other tools.
Is there any macro/formula which takes the first value of Tool 1(8), and compares with the other tool values(4 & 3), if it is the largest value - highlights it green, if lowest value highlights it Red, if neither than remains as it is. This logic loops through all the values in Tool 1 column.
Appreciate any help/tips. Thanks for your time.