Hey all,


I am trying to figure out a way to format a set of number so that the
number with the max value has a cell color of red, the next max value
has a cell color of yellow, the 3rd max value has a cell color of blue,
the 4th max value has a cell color of green, and the 5th max value has
a cell color of grey. If this is confusing replace the "max value" with
"top scoring". There will not be any ties.


For example

02
23 (yellow)
05
27 (red)
08
19 (blue)
01
10 (grey)
00
14 (green)
06


Has anyone done something similar to this?

Lance


--

Lance Hoffmeyer