color coding largest 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?

 

[Tom Ogilvy]

As your second conditional format condition.
=AND(ISNUMBER($P7),$P7>=LARGE($P$3:$P$60,10))

If the first is satisfied, then second won't be applied.

 

[Bob Phillips]

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?

Robert

Try this

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

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)