In the example below I am trying to use conditional formatting to highlight any of the names that have spent no money on an item (so in this case Jane and Sara would be highlighted). Could you please help with the correct formula to use here? Thank you!
<tbody>
</tbody>
Hat | Gloves | |
John | $10 | $5 |
Jane | $5 | $0 |
Steve | $10 | $5 |
Sara | $0 | $10 |
<tbody>
</tbody>