Ask Your Question
0

How to highlight highest and lowest values in LirbreOffice Calc

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

birdboy272 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. http://imgur.com/8vVTNvO

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

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:

https://wiki.documentfoundation.org/D...
4.x.branch
2 Entering, Editing, and Formatting Data. - Using conditional formatting (page 29)

Also a video:
http://www.youtube.com/watch?v=zXQnBG...

20161215 Edited

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

ConditionalFormat_Laargest_Smallest.ods

I hope more understandable now.:)

edit flag offensive delete link more

Comments

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 4,536 times

Last updated: Dec 15 '16