Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 11th 09, 05:52 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 36
Default Conditional Formatting, multiple conditions

Help! I'm using Excel 2007. I'm comparing old rates and tiers on a type of
account to the new rates and tiers. Part of my worksheet is as below:


A B C D
E
1 Account OldCutoff1 OldRate1 NewCutoff1 NewRate1
2 OldCutoff2 OldRate2 NewCutoff2 NewRate2
3 OldCutoff3 OldRate3 NewCutoff3 NewRate3
4 OldCutoff4 OldRate4 NewCutoff4 NewRate4

A1:A4 is merged into one cell. I would like to conditionally format
(highlight) this cell if any of the newcutoffs or rates are different than
the corresponding old cutoffs or rates. Should I do "if B1<D1 OR C1<E1 OR
B2<D2 etc." or "if B1=D1 AND C1=E1 AND B2=D2 etc"??

I tried doing something like adding everything together into a unneccessary
total, then comparing the 2 totals, but that wouldn't work in the case of one
rate or cutoff going up by the same amount that another rate or cutoff
decreased.


As always, any assistance is appreciated!

  #2   Report Post  
Old May 11th 09, 07:25 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
Posts: 1,104
Default Conditional Formatting, multiple conditions

You do not need an IF formula; but a formula that evaluates to either True
or FALSE
Select he cells in the A column, I will assume the first one is A1.
One the conditional format dialog and use this formula
=OR(B1<D1,C1<E1)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Wanda" wrote in message
...
Help! I'm using Excel 2007. I'm comparing old rates and tiers on a type
of
account to the new rates and tiers. Part of my worksheet is as below:


A B C D
E
1 Account OldCutoff1 OldRate1 NewCutoff1 NewRate1
2 OldCutoff2 OldRate2 NewCutoff2 NewRate2
3 OldCutoff3 OldRate3 NewCutoff3 NewRate3
4 OldCutoff4 OldRate4 NewCutoff4 NewRate4

A1:A4 is merged into one cell. I would like to conditionally format
(highlight) this cell if any of the newcutoffs or rates are different than
the corresponding old cutoffs or rates. Should I do "if B1<D1 OR C1<E1
OR
B2<D2 etc." or "if B1=D1 AND C1=E1 AND B2=D2 etc"??

I tried doing something like adding everything together into a
unneccessary
total, then comparing the 2 totals, but that wouldn't work in the case of
one
rate or cutoff going up by the same amount that another rate or cutoff
decreased.


As always, any assistance is appreciated!



  #3   Report Post  
Old May 11th 09, 08:35 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 36
Default Conditional Formatting, multiple conditions

Thanks! Worked great!

"Bernard Liengme" wrote:

You do not need an IF formula; but a formula that evaluates to either True
or FALSE
Select he cells in the A column, I will assume the first one is A1.
One the conditional format dialog and use this formula
=OR(B1<D1,C1<E1)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Wanda" wrote in message
...
Help! I'm using Excel 2007. I'm comparing old rates and tiers on a type
of
account to the new rates and tiers. Part of my worksheet is as below:


A B C D
E
1 Account OldCutoff1 OldRate1 NewCutoff1 NewRate1
2 OldCutoff2 OldRate2 NewCutoff2 NewRate2
3 OldCutoff3 OldRate3 NewCutoff3 NewRate3
4 OldCutoff4 OldRate4 NewCutoff4 NewRate4

A1:A4 is merged into one cell. I would like to conditionally format
(highlight) this cell if any of the newcutoffs or rates are different than
the corresponding old cutoffs or rates. Should I do "if B1<D1 OR C1<E1
OR
B2<D2 etc." or "if B1=D1 AND C1=E1 AND B2=D2 etc"??

I tried doing something like adding everything together into a
unneccessary
total, then comparing the 2 totals, but that wouldn't work in the case of
one
rate or cutoff going up by the same amount that another rate or cutoff
decreased.


As always, any assistance is appreciated!






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
Conditional Formatting - Multiple Conditions with OR() EEB3 Excel Worksheet Functions 5 February 24th 08 12:10 AM
conditional formatting for multiple sets of conditions steve Excel Discussion (Misc queries) 9 August 15th 07 07:00 PM
Multiple conditions for conditional formatting plf100 Excel Worksheet Functions 4 September 27th 06 11:00 AM
Multiple conditions in Conditional Formatting guilbj2 Excel Discussion (Misc queries) 0 June 28th 06 09:09 PM
Banding with Conditional Formatting with Multiple Conditions Geremia Doan Excel Worksheet Functions 7 February 2nd 05 03:14 PM


All times are GMT +1. The time now is 01:59 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017