Need conditional formatting formula to highlight top ten values i.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
oops, forget that, it is the top n where n = the count-9

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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
 
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 : )
 
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)
 
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!
 
Glad you cracked it.

Bob


lightninbug said:
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!
Click to expand...
 
Back
Top