"mjones" wrote in message
ups.com...
On Sep 13, 12:40 pm, "Franz Verga" wrote:
Nel ups.com,
mjones ha scritto:





Hi All,

70 people are voting on 15 products tomorrow night in a serious of
rounds.

Each time I'll end up with 15 numbers in a range. Since it will be on
a presentation, it will be nice if the top ones turn red or highlight
somehow.

Top number will change each time, ie. 10 picked the first round, 5 the
next, etc

I think this is a conditional format, but I have no idea how to do
this.

Any help would be appreciated.

Thanks,

Michele

Hi Michele,

If your numbers are in the range A1:A15, selece the range (A1 should be
the
active cell) and try to use this formula in the conditional formatting
(use
the option "Formula is"):

=A1=LARGE($A$1:$A$15,5)

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy- Hide quoted text -

- Show quoted text -

Hey, that works great. Thanks.

Since I have to change the number of winners each round, can I put the
# in a cell (A4) and change the last 5 to whatever is in the cell?


Yes. Try it like this:

=A1=LARGE($A$1:$A$15,$A$4)



But then I actually ended up with 7 red values. That's because there
were two ties. Can I total the number of winners (red values) in the
range in C34? The range is C5 to C32.

Try this:

=COUNTIF(C5:C32,"="&LARGE(C5:C32,5))

Or:

=COUNTIF(C5:C32,"="&LARGE(C5:C32,A4))

--
Biff
Microsoft Excel MVP