Conditional formatting

[Barney]

Hi,
In a row of 6 numbers I want to highlight the 3 largest numbers. If the row
contains 7 or 8 numbers, I want to highlight the 4 largest of those numbers.
If the row contains 9 or 10 numbers, I want to highlight the 5 largest of
those numbers. Any suggestions on how to make this work?
Thanks in advance, Barney

[Dirk Van de moortel]

"Barney" <postonbl@yahoo.com> wrote in message news:4m8tf.82355$aS5.36606@bignews4.bellsouth.net...
> Hi,
> In a row of 6 numbers I want to highlight the 3 largest numbers. If the row
> contains 7 or 8 numbers, I want to highlight the 4 largest of those numbers.
> If the row contains 9 or 10 numbers, I want to highlight the 5 largest of
> those numbers. Any suggestions on how to make this work?

Supposing the numbers are in column A, then you can do this:

If
Cell Value is
greater than or equal to
=MEDIAN(A:A)
then
highlight

Dirk Vdm

[Bob Phillips]

I answered in other thread, but copied here for info

Conditional Formatting will do that.

Let's start by assuming the data is in row 21, then

Select row 21
Menu Format>Conditional Formatting
Change Condition 1 to Formula Is
Add a formula of
=ISNUMBER(MATCH(A21,LARGE($21:$21,ROW(INDIRECT("1:"&INT((COUNTA($21:$21)+1)/
2)))),0))
Click the Format button
Select the Pattern Tab
Select an appropriate highlighting colour
OK
OK

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Barney" <postonbl@yahoo.com> wrote in message
news:4m8tf.82355$aS5.36606@bignews4.bellsouth.net...
> Hi,
> In a row of 6 numbers I want to highlight the 3 largest numbers. If the
row
> contains 7 or 8 numbers, I want to highlight the 4 largest of those
numbers.
> If the row contains 9 or 10 numbers, I want to highlight the 5 largest of
> those numbers. Any suggestions on how to make this work?
> Thanks in advance, Barney
>
>

[Dirk Van de moortel]

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message news:%23$khxDUDGHA.532@TK2MSFTNGP15.phx.gbl...
> I answered in other thread, but copied here for info
>
> Conditional Formatting will do that.
>
> Let's start by assuming the data is in row 21, then
>
> Select row 21
> Menu Format>Conditional Formatting
> Change Condition 1 to Formula Is
> Add a formula of
> =ISNUMBER(MATCH(A21,LARGE($21:$21,ROW(INDIRECT("1:"&INT((COUNTA($21:$21)+1)/
> 2)))),0))
> Click the Format button
> Select the Pattern Tab
> Select an appropriate highlighting colour
> OK
> OK

Select row 21
Menu Format, Conditional formatting
Cell Value is
greater than or equal to
=MEDIAN(21:21)


Dirk Vdm