Greetings,

I am trying to write a Conditional Format that is looking at 3
columns. Column A is the reference, it has about 6 different entries.
I need to take all of the amounts in column B that have the same
column A items and add them together. Then do the same for column C.
Then see if the totals for column B are equal to the totals in column
C.

Anyone know how this can be done?

Any help would be appreciated.

TIA

-Minitman

Maybe you could use the following cond. format for col c
cell value is
not equal to
=C1-(SUMIF($A$1:$A$8,A1,$B$1:$B$8)-SUMIF($A$1:$A$8,A1,$C$1:$C$8))


- Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=27584

Hey Mangesh,

Thanks for the code. I am not sure how to use it

I failed to mention that this Conditional Format will be in 10 columns
A-J on 250 rows ( the rows is easy - $A$1:$A$250).

I must confess that I do not understand how this works.

I am trying to get as a result to highlight all ten cells in the row
of any A that is missing a total B for that day-account (1st color) or
a total C for that day-account (2nd color).

In real terms, The items in B are the items from deposit tickets and
the items in C are the entries from the bank statements (there are 6
different bank accounts over an 11 year period). The items in A are a
combined day-account number that is used to primarily get all of the
info (deposit tickets and bank statements) for each day to see if
anything is missing (bank statements or deposit tickets). If a
deposit ticket is missing I need each cell in the row to change to one
color. If the bank statement is missing from any of the accounts, I
need for these same rows to change to a different color.
If a bank statement is missing, I cannot know if any deposit tickets
for that account are missing.

I hope this explains what I am trying to do a little bit better.



On Sat, 6 Nov 2004 00:17:32 -0600, mangesh_yadav
wrote:


Maybe you could use the following cond. format for col c
cell value is
not equal to
=C1-(SUMIF($A$1:$A$8,A1,$B$1:$B$8)-SUMIF($A$1:$A$8,A1,$C$1:$C$8))


- Mangesh

Thanks Mangesh,

I stand corrected, I was able to use with only a slight modification.

-Minitman

On Sat, 06 Nov 2004 02:33:40 -0600, Minitman
wrote:

Hey Mangesh,

Thanks for the code. I am not sure how to use it

I failed to mention that this Conditional Format will be in 10 columns
A-J on 250 rows ( the rows is easy - $A$1:$A$250).

I must confess that I do not understand how this works.

I am trying to get as a result to highlight all ten cells in the row
of any A that is missing a total B for that day-account (1st color) or
a total C for that day-account (2nd color).

In real terms, The items in B are the items from deposit tickets and
the items in C are the entries from the bank statements (there are 6
different bank accounts over an 11 year period). The items in A are a
combined day-account number that is used to primarily get all of the
info (deposit tickets and bank statements) for each day to see if
anything is missing (bank statements or deposit tickets). If a
deposit ticket is missing I need each cell in the row to change to one
color. If the bank statement is missing from any of the accounts, I
need for these same rows to change to a different color.
If a bank statement is missing, I cannot know if any deposit tickets
for that account are missing.

I hope this explains what I am trying to do a little bit better.



On Sat, 6 Nov 2004 00:17:32 -0600, mangesh_yadav
wrote:


Maybe you could use the following cond. format for col c
cell value is
not equal to
=C1-(SUMIF($A$1:$A$8,A1,$B$1:$B$8)-SUMIF($A$1:$A$8,A1,$C$1:$C$8))


- Mangesh

See http://www.sulprobil.com/html/vacation_plan.html

(use at your own risk)

It's an example which looks at 2 cells and you can copy the conditional
format into other rows.

HTH,
Bernd