conditional formatting across rows
 

Forgive me for posting twice, I just saw this section


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?

conditional formatting across rows
 

Suppose you want to format the cell in column F.

Assume your numeric data is in the range A1:E3

In Excel 2007

Select the range of cells to format. Assume this range is F1:F3
Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a
formula to determine which cells to format
Enter this formula in the box below:
=COUNTIF($A1:$E1,"0")=3
Click the Format button
Select the desired style(s)
OK out

In Excel versions 2003 and earlier

Select the range of cells to format. Assume this range is F1:F3
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=COUNTIF($A1:$E1,"0")=3
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"learningdba" wrote in message
...
Forgive me for posting twice, I just saw this section


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?