Multi-column conditional formatting
 

Can someone help me here.

Imagine this

A B C D E WINNER?
32423 1231 23524 234234 2662
0 999999 0 0 0
123123 232139 0 0 0

Let's say these are sales figures and I want to run a promotion that if you
have sales in 3 categories over $0 -- you win and that puts a GREEN box in
the winner column. I don't want to award someone that sells the most money
but just in 1 region (like row 2). You have to get 3 regions over $0 to win
($0) like row 1. Row 2 and Row 3 sold more, but not in 3 places so they
don't win. Don't ask me why -- dumb competitiion, but those are the rules.

How do I program this. I need to carry logic all the way to the Winner
column that says is this 0 and then conditionally format that expression.

Any ideas?

Multi-column conditional formatting
 

See your other post

--
Biff
Microsoft Excel MVP


"learningdba" wrote in message
...
Can someone help me here.

Imagine this

A B C D E WINNER?
32423 1231 23524 234234 2662
0 999999 0 0 0
123123 232139 0 0 0

Let's say these are sales figures and I want to run a promotion that if
you
have sales in 3 categories over $0 -- you win and that puts a GREEN box in
the winner column. I don't want to award someone that sells the most money
but just in 1 region (like row 2). You have to get 3 regions over $0 to
win
($0) like row 1. Row 2 and Row 3 sold more, but not in 3 places so they
don't win. Don't ask me why -- dumb competitiion, but those are the rules.

How do I program this. I need to carry logic all the way to the Winner
column that says is this 0 and then conditionally format that expression.

Any ideas?

Multi-column conditional formatting
 

Hi,

Assume the Winner column is F and the first row of data is row 2, then
select the cells F2:F100 or whatever and choose Format, Conditional
Formatting, pick Formula is from the first drop down and enter the following
formula in the second box:

=COUNTIF($A2:$E2,"0")2

Choose Format, pick Patterns and pick a color.

--
Thanks,
Shane Devenshire


"learningdba" wrote:

Can someone help me here.

Imagine this

A B C D E WINNER?
32423 1231 23524 234234 2662
0 999999 0 0 0
123123 232139 0 0 0

Let's say these are sales figures and I want to run a promotion that if you
have sales in 3 categories over $0 -- you win and that puts a GREEN box in
the winner column. I don't want to award someone that sells the most money
but just in 1 region (like row 2). You have to get 3 regions over $0 to win
($0) like row 1. Row 2 and Row 3 sold more, but not in 3 places so they
don't win. Don't ask me why -- dumb competitiion, but those are the rules.

How do I program this. I need to carry logic all the way to the Winner
column that says is this 0 and then conditionally format that expression.

Any ideas?