Duplicate numbers should all have the same format, ie all the highest #'s are
red, the second highest #'s are all blue, etc...

"Ron Rosenfeld" wrote:

On Wed, 11 May 2005 20:53:02 -0700, "John"
wrote:

I'd like to highlight the 3 highest numbers in a column - a different color
for each high number. I figured I'd use conditional formatting and LARGE, but
there are duplicate numbers, which should all be highlighted.

Also is there a limit on the length of a formula?

Thanks!!!!

What do you want to happen in the event of duplicate numbers?


--ron