So I've got this spreadsheet open using OpenOffice Calc (ver 3.3.0) and its set up a little like this:
A B C D 1.name quantity price total 2.foo 10 10 100 3.bar 20 6 120 4.red 30 7 210
Each cell in the "total" column is obtained by multiplying the two cells to the left of it, and what I'm trying to do is to get it so that Calc highlights the highest value in the total column (even better if it could highlight the entire row). I've tried using MAX(D1:D4) in the Conditional Formatting section, but it highlights multiple values. How do I get it to highlight just the highest value?