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

[sv.thiyagarajan]

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

Highlighting Bottom 5 Values Using Conditional Formatting

After Using Conditional Formatting

LibreOffice Calc Screen Shot

[mikekaganski]

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…

[JohnSUN]

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?

[sv.thiyagarajan]

Using Conditional Formatting

[PKG]

@sv.thiyagarajan

But, I can 't do that in LibreOffice Calc

Why not?

[sv.thiyagarajan]

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…

[sv.thiyagarajan]

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

[PKG]

I get this

[sv.thiyagarajan]

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