How to High Light Top 5 and Bottom 5 Values in Libreoffice Calc Data?

Hi Friends,
I want to highlight Top 5 Values and Bottom 5 Values in the Data, I Can do this in MS Excel. But, I can 't do that in LibreOffice Calc ? any Idea

MS Excel Screen Shot

Highlighting Top 5 Values Using Conditional Formatting

image

image

Highlighting Bottom 5 Values Using Conditional Formatting

image

image

After Using Conditional Formatting

LibreOffice Calc Screen Shot

It might seem at the first glance, that anyone trying to check how you did in in Excel, and in Calc, would not find it easy using the screenshots…

And at the second glance, and at the third…
If your formula with commas returns an error, please check the Tools - Options - LibreOffice Calc - Formula - Separators option.

Perhaps Calc expects you to use a semicolon instead of a simple comma?

Using Conditional Formatting

Why not?

Hi I Tried that One But, i Could not get that Top 5 , Bottom 5… Only Highlighting Top and Bottom Values 10 and 1 instead Of 10,9,8,7,6 and 1,2,3,4,5

Here, is the Screen Shots…

I want to Highlight the Top 5 and Bottom 5 Values, I want the Result Like this

But, i am getting only…in LibreOffice Calc

I get this

2 Likes

Thanks, PKG… As per Your Screen Shot…Now, I am getting Result Which is I want…
Here, is the Result

Top 5 - High lighting

Bottom 5 - High lighting