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
|