Ask Your Question

How to highlight highest and lowest values in LibreOffice Calc [closed]

asked 2013-09-29 21:37:56 +0100

birdboy272 gravatar image

updated 2020-09-16 17:11:41 +0100

Alex Kemp gravatar image

I am making a stat sheet for a Lan party I am having. I would like to highlight the highest and lowest values in each column. For example the three people with the most kills with have their kill count highlighted. I have an example but do not know how to replicate it.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-16 17:11:13.612480

1 Answer

Sort by » oldest newest most voted

answered 2013-09-29 21:59:55 +0100

m.a.riosv gravatar image

updated 2016-12-15 02:15:24 +0100

There is needed to use conditional formatting (Menu/Format/Conditional Formatting), a better explanation about the new conditional formatting in 4.x branch is founded in documentation:
2 Entering, Editing, and Formatting Data. - Using conditional formatting (page 29)

Also a video:

20161215 Edited

Added a sample file with a conditional format to color 3 largest and 3 smallest values.


I hope more understandable now.:)

edit flag offensive delete link more


The question you are answering is not answered in the links you provided

grfiv gravatar imagegrfiv ( 2015-11-08 22:26:57 +0100 )edit

Indeed, this answer absolutely doesn't answer the question, or if it does it's well hidden.

rautamiekka gravatar imagerautamiekka ( 2016-12-15 00:31:53 +0100 )edit

Agreed. If one can highlight the top value in a column, row or area, one woul imagine this would be an easy fix.

Skidd gravatar imageSkidd ( 2017-10-26 18:12:33 +0100 )edit

Question Tools

1 follower


Asked: 2013-09-29 21:37:56 +0100

Seen: 5,732 times

Last updated: Sep 16