In the example below, I need to conditionally format (in red text) the name that has the highest spend. So in the example Jane Doe would be conditionally formatted to red text. Could you please provide help on the formula to use for this? Thank you!
<tbody>
</tbody>
John Smith | $20 |
Jane Doe | $25 |
Don Johnson | $10 |
<tbody>
</tbody>