Ooops.. It's should be like this : Was missing $ sign
=$C10=LARGE($C10:$C$40,1) color Red.
=$C10=LARGE($C10:$C$40,2) color Orange
=$C10=LARGE($C10:$C$40,3) color Yellow
But that only works for Column C, don't know how to do it for 3 range.
Possibly using VBA.
Good Luck
John


"John" wrote in message
...
Hi Ken
If I understand the question right;
Select range B10 To B40 starting at B10; goto Conditional Formatting, your 3
formulas are
=$C10=LARGE($C10:$C40,1) color Red.
=$C10=LARGE($C10:$C40,2) color Orange
=$C10=LARGE($C10:$C40,3) color Yellow
HTH
John
"Ken" wrote in message
...
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