Need conditional formatting formula to highlight top ten values i.

Hello,
I have seen this done with conditional formatting, where the top ten values
in a column are highlighted, But for the life of me I can not come up with a
formula to do it. Does anyone know a formula for this? Thanks so much.

Try:

=RANK(A1,$A$1:$A$20)<=10

Tim C

"lightninbug" <lightninbug@discussions.microsoft.com> wrote:

> Hello,
> I have seen this done with conditional formatting, where the top ten
> values
> in a column are highlighted, But for the life of me I can not come up with
> a
> formula to do it. Does anyone know a formula for this? Thanks so much.

Assuming the values are in B1:B15, this should do it

=B1>=LARGE($B$1:$B$15,10)

--

HTH

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


"lightninbug" <lightninbug@discussions.microsoft.com> wrote in message
news:D0397201-1F89-48A1-9BCB-BB3C73D7E8C0@microsoft.com...
> Hello,
> I have seen this done with conditional formatting, where the top ten
values
> in a column are highlighted, But for the life of me I can not come up with
a
> formula to do it. Does anyone know a formula for this? Thanks so much.

oops, forget that, it is the top n where n = the count-9

--

HTH

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


"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:OsJMTQo$EHA.3504@TK2MSFTNGP12.phx.gbl...
> Assuming the values are in B1:B15, this should do it
>
> =B1>=LARGE($B$1:$B$15,10)
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "lightninbug" <lightninbug@discussions.microsoft.com> wrote in message
> news:D0397201-1F89-48A1-9BCB-BB3C73D7E8C0@microsoft.com...
> > Hello,
> > I have seen this done with conditional formatting, where the top ten
> values
> > in a column are highlighted, But for the life of me I can not come up
with
> a
> > formula to do it. Does anyone know a formula for this? Thanks so much.
>
>

Thanks Tim, I tried this and I did not get it to work
and
Thanks Bob, I tried the first formula and can not get it to work, and I am
not sure how you meant fo rme to edit it with you second response.

So anymore things to try? : )

I think I was suggesting you forget mine altogether, and use the other one
(that does work) :-).

Bob


"lightninbug" <lightninbug@discussions.microsoft.com> wrote in message
news:8FA71B40-E8CA-4623-AE16-57D3CEAA28F0@microsoft.com...
>
>
> Thanks Tim, I tried this and I did not get it to work
> and
> Thanks Bob, I tried the first formula and can not get it to work, and I am
> not sure how you meant fo rme to edit it with you second response.
>
> So anymore things to try? : )

Ok - I'll keep working with Tim's formula - I must be doing something wrong
since I can not get it to work. Thanks So Much! Have a great day : )

"Bob Phillips" wrote:

> I think I was suggesting you forget mine altogether, and use the other one
> (that does work) :-).
>
> Bob
>
>
> "lightninbug" <lightninbug@discussions.microsoft.com> wrote in message
> news:8FA71B40-E8CA-4623-AE16-57D3CEAA28F0@microsoft.com...
> >
> >
> > Thanks Tim, I tried this and I did not get it to work
> > and
> > Thanks Bob, I tried the first formula and can not get it to work, and I am
> > not sure how you meant fo rme to edit it with you second response.
> >
> > So anymore things to try? : )
>
>
>

Really? I tried Tim's and it worked great for me.

What does the data look like, and what is your exact formula?

--

HTH

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


"lightninbug" <lightninbug@discussions.microsoft.com> wrote in message
news:426EB16F-EB8E-443F-A966-AB5E54F72CF9@microsoft.com...
> Ok - I'll keep working with Tim's formula - I must be doing something
wrong
> since I can not get it to work. Thanks So Much! Have a great day : )
>
> "Bob Phillips" wrote:
>
> > I think I was suggesting you forget mine altogether, and use the other
one
> > (that does work) :-).
> >
> > Bob
> >
> >
> > "lightninbug" <lightninbug@discussions.microsoft.com> wrote in message
> > news:8FA71B40-E8CA-4623-AE16-57D3CEAA28F0@microsoft.com...
> > >
> > >
> > > Thanks Tim, I tried this and I did not get it to work
> > > and
> > > Thanks Bob, I tried the first formula and can not get it to work, and
I am
> > > not sure how you meant fo rme to edit it with you second response.
> > >
> > > So anymore things to try? : )
> >
> >
> >

How very strange you are right it does work on one of my xsheets, but will
not work on the other. Why would that be? In both xsheets the column where I
want to highlight the top are dollar values. Have any ideas?

The spreadsheet that it works on is about 32 colums and 400 rows of
vendor/article information with the last column being the Dollar value of the
product .

The other wher it does nto work, is 3 columns by 100 rows with an article
number, a site and total dollar value in that last column
I am trying to rank the top ten articles by dollar, as the list is to be
kept in article order.... ( otherwise it would be easier to just sort and
have the ten at the top....)

DUHHH -
Thanks for your patience Bob! In formula that did not work, my reference
number was still absolute! And Tim, my apologies this was so simple I should
have got it!

Have a great day!

>
>
> How very strange you are right it does work on one of my xsheets, but will
> not work on the other. Why would that be? In both xsheets the column where I
> want to highlight the top are dollar values. Have any ideas?

Glad you cracked it.

Bob


"lightninbug" <lightninbug@discussions.microsoft.com> wrote in message
news:3B93C8CD-A775-4728-AA3F-ABC7C9F411F6@microsoft.com...
> DUHHH -
> Thanks for your patience Bob! In formula that did not work, my reference
> number was still absolute! And Tim, my apologies this was so simple I
should
> have got it!
>
> Have a great day!
>
> >
> >
> > How very strange you are right it does work on one of my xsheets, but
will
> > not work on the other. Why would that be? In both xsheets the column
where I
> > want to highlight the top are dollar values. Have any ideas?