Conditional Formatting based on cell value

Hi @ dcgrove

I'm pretty sure this is the way:

Please Login or Register  to view this content.

I took as example column B.
and placed in cell O3 "Minor"
then in Conditional Format / Use Formula copied the formula.
It is finding the Rank , but despite I asked to show all the cells with Rank<6 in order to get up to 5
it highlights only 3 or 4 cells
Someone reading us can help to find where I went wrong .

I cheated changing the number 6 for 13 and 14 and it highlighted the top 5

Clayton Please upload your file to the forum. Not all members are able - or willing - to access file-hosting sites

Hi Clayton @dcgrove

I already realized my mistake.
the correct formula for the conditional formating is:

Please Login or Register  to view this content.

this example works for the second column, and "Critical" filter
I've used a small list for the conditions in Column O, but you can use the words directly in the formula.
this shows the 5 highest values in the rank... but if you have a tie in the fifth there will be more than 5 cells highlighted

Captura.JPG

Your explanation is not clear at all. You want the top 5 but only give 3 levels. How is that supposed to be applied without a definition of what each level is? Column M doesn't make any sense at all the way it stands as all levels seem to apply to a host of different values.

Your explanation is not clear at all. You want the top 5 but only give 3 levels. How is that supposed to be applied without a definition of what each level is? Column M doesn't make any sense at all the way it stands as all levels seem to apply to a host of different values.

I Just took a guess.

I'm just speculating here,

What I understood from Clayton's questions is:
In each column filter all the values which are, let's say, "Critical" and mark from them the top 5
then do the same filtering for "Major" and then for "Minor"
so, at the end you'll have in each column, 5 cells marked as top 5 critical, another 5 cells marked as top 5 major and 5 marked as minor
But if you have ties, then there will be more than 5 cells marked as you can see in yellow b'cause the repeated value 7, or in blue with repeated value 5