Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
In excel home tab, Select Conditional Formatting, after select Top/Bottom rules.
I hope, it will work.
Go to "Home - Conditional Formatting - Top bottom rules.
My Solution By Using 2 Function To achieve this :
1- large(array,Rank)
2- Small(array,Rank)
Example:
=LARGE(A1:A5,4) will return the fourth top value of array of data
=small(A1:A5,4) will return the fourth least value of array of data