# Bank Reconciliation

1. ## Bank Reconciliation

Book Value: Bank numbers:
30 100
60 100
90 4.90
100 390
100 10
100 100
400 500
400 30
4.90 50
30 65

In Column A the book value, is there are way that I can get it to highlight when 2 or more numbers in Column B equal one of the numbers? Ex: 39+10=400 on the right.

In Column B the bank value, can I get it to highlight if there is a repeating number, but only once? for example the 100's, to only highlight once on the right?

Thanks! This is eating up my time at work, and I have so much to do!

2. ## Re: Bank Reconciliation

So I'm not entirely sure what you mean for the highlighting of column A, can you be more specific please?

For column B, try using the following formula in conditional formatting:

=IF(ROW(B1)-ROW(\$B\$1)+1=IF(COUNTIF(\$B\$1:\$B\$8,B1)>1,MATCH(B1,\$B\$1:\$B\$8,0)),TRUE)

B1:B8 was just the dummy range I was using, replace that with whatever range you need

3. ## Re: Bank Reconciliation

Thanks for commenting,

I would like Column A to highlight (whichever total equals to it), if column b totals add to one number in it.

Ex: 390+10 in column B equal 400 in A, A:400 highlights blue

30 100
60 100
90 4.90
100 390
100 10
100 100
400 500
400 30
4.90 50
30 65

and I would like column B to highlight the figure that is repeated in column A.

Ex: A:100 B:100 highlights red.

4. ## Re: Bank Reconciliation

Help much appreciated! Thanks!

5. ## Re: Bank Reconciliation

Anyone have any ideas? Tips ?

6. ## Re: Bank Reconciliation

So for column B, it's only if it is equal to the value next to it in column A? So the 30 100 won't highlight, but the 100 100 will? If so, in conditional formatting enter =B1=A1, then drag it down.

The only thing I can think of for column B would be to have a 'square' of calculations showing all the possible sums. So if you have 10 records, you would have a 10 row x 10 column set of calcs that would give you all possible sums. I'm probably not explaining this very well, but i've attached an example of what i'm talking about. Let me know if you want me to run you through it.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1