Remember Me?

#1
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
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
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
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
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
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!

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post EEB3 Excel Worksheet Functions 5 February 24th 08 12:10 AM steve Excel Discussion (Misc queries) 9 August 15th 07 07:00 PM plf100 Excel Worksheet Functions 4 September 27th 06 11:00 AM guilbj2 Excel Discussion (Misc queries) 0 June 28th 06 09:09 PM Geremia Doan Excel Worksheet Functions 7 February 2nd 05 03:14 PM

All times are GMT +1. The time now is 09:33 PM.