View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mjones mjones is offline
external usenet poster
 
Posts: 86
Default Highest 5 numbers in a range turn red

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