You are correct on the conditional formatting. In general you want to know if
the number in the cell is greater than or equal to the 5th largest number.
Give this a try..

Place your cursor in Cell A1 and then select the entire column. (all of
Column a is highlighted with cell A1 as the active cell). Now select
Format|Conditonal Format - Formula is
=A1=LARGE($A:$A,5)
And change the format to red...

Note that you could end up with more than 5 cells highlighted if there is a
tie in fifth spot...
--
HTH...

Jim Thomlinson


"mjones" wrote:

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