Wise people of the forum.. I need help. How do I Conditional Format each row separately to show the locations that exceeds the average of all locations in the row? Once it set up for the first row how do I copy it down to the remaining rows?
<tbody>
</tbody>
Thanks you so much in advance. Your time is very much appreciated.
KH
Location 1 | Location 2 | Location 3 | Location 4 | Location 5 | Location 6 | |
Repair 1 | $ 7.73 | $ 0.83 | $ 4.29 | $ 8.31 | $ 1.01 | $ 1.10 |
Repair 2 | $ - | $ 2.11 | $ 2.60 | $ 5.15 | $ 1.19 | $ 2.14 |
Repair 3 | $ - | $ 0.73 | $ 1.28 | $ 4.32 | $ 0.17 | $ 1.64 |
Repair 4 | $ 0.78 | $ 0.82 | $ 0.64 | $ 6.75 | $ 0.05 | $ 0.55 |
<tbody>
</tbody>
Thanks you so much in advance. Your time is very much appreciated.
KH