Ken
It's not clear to me where the max value, 2nd value and 3rd value are to be
found.

Do you want b10 to be formatted based on the values in that row i.e. c10,g10
& k10 or the max values to be found in the whole ranges c,g and k.

It's just that you specify B10 conditions but not all col b.

Or is it me??

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Ken" wrote:

Excel2003 ... Conditional Format?

Range B10:B40 contains Text
Range C10:C40 contains numbers
Range G10:G40 "
Range K10:K40 "

I am looking for a Conditional Formula in Range B10:B40

B10 Conditions ... based on Ranges (C10:C40, G10:G40, K10:K40)

1: RED ... MAX Value
2: ORG ... 2nd Largest Value
3: YEL ... 3rd Largest Value

I know how to set Cond Colors, but I am stuck on Cond Formula to place in
Range B10:B:40 ... & Unfortunately, I am sure I have written this much more
complicated then it is ???

My "Thanks" in advance to the many Excel Magicians that support these boards
... Kha