sorting and highlighting in a list

[Robert L. Salisbury]

I have a list of 60 items that change slightly on a weekly basis. Currently
I highlight(color code) the five with the largest weekly increases. I do
this with the following conditional format formula.

=AND(ISNUMBER($P7),$P7>=LARGE($P$3:$P$60,5))

I would like to highlight(color code) another group of five with the next
largest weekly increases but have been unable to determine the appropriate
formula.

Can anyone help?

 

[Kieran]

Try

=AND(ISNUMBER($P9),$P9<=LARGE($P$3:$P$60,5),($P9>LARGE($P$3:$P$60,10)))
as the second conditional format.

 

[Dave Peterson]

Couldn't you just look to see if it's between the 5th largest and the 10th
largest:

=AND(ISNUMBER(P7),P7<LARGE($P$3:$P$60,5),P7>=LARGE($P$3:$P$60,10))

I put the formula in P7, but I took out the $ signs--I didn't want the absolute
reference for P7. I'm kind of surprised you have it in your formula.