Conditional Format?
 

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

Conditional Format?
 

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

Conditional Format?
 

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

Conditional Format?
 

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


"Russell Dawson" wrote:

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

Conditional Format?
 

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

Conditional Format?
 

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