Hi Ken
If no one comes up with a answer, I can do it but I need 3 column for each color
and each range. Total of 9 column to create a "True/False" table.
If you're interested, I will post a link for a demo file that you can look at.
Regards
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