OpenOffice Calc - Highlighting the higest value in a column

Posted by cornjuliox on Super User See other posts from Super User or by cornjuliox
Published on 2012-08-30T14:17:34Z Indexed on 2012/08/30 15:40 UTC
Read the original article Hit count: 243

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?

© Super User or respective owner

Related posts about openoffice.org

Related posts about spreadsheet