Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,344
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting cells in a column with conditional formatting? shamor Excel Discussion (Misc queries) 8 May 19th 08 10:11 PM
match in multi-column and multi-row array sloth Excel Discussion (Misc queries) 14 September 1st 06 10:33 PM
Conditional formatting - multi-item text list String Excel Worksheet Functions 4 August 5th 06 02:06 PM
Column conditional formatting Rhys'''' Pieces Excel Discussion (Misc queries) 2 April 10th 06 04:25 PM
column to column conditional formatting won't work, need formula rrupp Excel Worksheet Functions 1 August 23rd 05 10:06 PM


All times are GMT +1. The time now is 09:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"