Highest/Lowest Values

[red726]

Hi all! I'm having a problem.

I'm aware of the CF method of highlighting the 5 highest/lowest values in a row or column, but what if these numbers aren't adjacent?

Here's my problem:

I have values in G4, G6, G8, G10, ... G22 and I want to highlight the top 5 highest values in those cells. As you can see they're not adjacent... I need help

 

[gsbelbin]

I had a very quick stab at this and tried defining the cells G4, G6 etc as a range (myrange) and then selecting those cells and applying the conditional formatting formula

=G4>=LARGE(myrange,5)

Seems to work fine

 

[kidwispa]

Or name the range as suggested in the previous post and use RANK...

=RANK(G4,myrange,1)