View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert L. Salisbury Robert L. Salisbury is offline
external usenet poster
 
Posts: 2
Default color coding largest in a list

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?