color coding largest in a list

  • Thread starter Thread starter Robert L. Salisbury
  • Start date Start date
R

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?
 
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.
 
Robert L. Salisbury said:
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?
Click to expand...


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)
 
Back
Top