Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting 2 rows only | Excel Discussion (Misc queries) | |||
Conditional formatting rows | Excel Discussion (Misc queries) | |||
Conditional formatting for rows? | New Users to Excel | |||
Conditional Formatting of Rows | Excel Discussion (Misc queries) | |||
Conditional Formatting for rows... | Excel Discussion (Misc queries) |