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
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
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