Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

color coding largest in a list

0 views
Skip to first unread message

Robert L. Salisbury

unread,
Jan 7, 2004, 8:31:19 AM1/7/04
to
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

unread,
Jan 7, 2004, 8:58:46 AM1/7/04
to
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.

--
Regards,
Tom Ogilvy


"Robert L. Salisbury" <rlsal...@c-air-s.com> wrote in message
news:HSTKb.5362$C01....@newssvr22.news.prodigy.com...

Bob Phillips

unread,
Jan 7, 2004, 9:05:27 AM1/7/04
to
"Robert L. Salisbury" <rlsal...@c-air-s.com> wrote in message
news:HSTKb.5362$C01....@newssvr22.news.prodigy.com...


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)

0 new messages