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?
 
This question was posted to additional newsgroups.
Please don't waste the time of people who volunteer their
time to answer in the Microsoft Excel newsgroups.

One of the threads where this question was answered was
in programming (another was in misc)
http://google.com/[email protected]

It is not a programming question. If not sure which newsgroup
to post to suggest the excel.misc newsgroup. No matter
which group you post to, your question will be answered.
http://www.mvps.org/dmcritchie/excel/xlnews.htm

excel.setup is not one of the newsgroups with the most traffic
and you are already up and running with Excel so this is the
wrong group. The three main groups are:]
excel.misc, excel.programming, and excel.worksheet.functions
 
Back
Top