conditional formatting across rows

[learningdba]

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?

 

[T. Valko]

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 tab>Styles>Conditional Formatting>Manage rules>New rule>Use 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 Format>Conditional 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