Hello,
I want to conditionally format the highest value in a row. However, I only want to highlight the most recent occurrence of that value. For instance, in the table below, I only want to highlight the 6 that occurred on 4/21/2018, not the one that occurred on 3/31.
When I try to write a formula to conditionally format, it highlights both instances. Can anyone help?
<tbody>
</tbody>
I want to conditionally format the highest value in a row. However, I only want to highlight the most recent occurrence of that value. For instance, in the table below, I only want to highlight the 6 that occurred on 4/21/2018, not the one that occurred on 3/31.
When I try to write a formula to conditionally format, it highlights both instances. Can anyone help?
4/28/2018 | 4/21/2018 | 4/14/2018 | 4/7/2018 | 3/31/2018 | 3/24/2018 | 3/17/2018 | 3/10/2018 |
4 | 6 | 4 | 5 | 6 | 4 | 3 | 4 |
<tbody>
</tbody>