Conditional Format?

[Ken]

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

 

[John]

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]

Russ ... (Hi)

I will rephrase question ... I need 3 conditions in each Cell Range (B10:B40)

For MAX Value in Range (C10:C40, G10:G40, K10:K40)
Cond Format RED corresponding Text Cell Range (B10:B40)

ie:

B20 RED ... if MAX Value found @ C20, G20 or K20 in Range (C10:C40, G10:G40,
K10:K40)

B20 ORG ... if 2nd Largest Value found @ C20, G20 or K20 in Range (C10:C40,
G10:G40, K10:K40)

B20 YEL ... if 3rd Largest Value found @ C20, G20 or K20 in Range (C10:C40,
G10:G40, K10:K40)

Hope this helps to better clarify ... Thanks ... Kha

 

[John]

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]

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