Create a helper column E in Bank Statement (sheet)

E1: =ISNUMBER(MATCH(1,INDEX(('Cash book'!$A$1:$A$3=B1)*('Cash
book'!$C$1:$C$3=D1),),))

copy down to E4

Select A1:E4 in Bank Statement sheet
Conditional Formatting

Formula Is: =$E1=TRUE
Format any color you like



"ACCAguy" wrote:

Hello All:

My problem is that I have 2 worksheets that I need to compare and highlight
the items that are similiar based on 2 criterion. In essence it is a
reconciliation of a bank account so I need to know the items that are
reconciling items plus those that might be on the bank's statement but not in
the cash book or vice versa so I can update the cash book and list the
reconciling items.

Here is a simplified version of the different worksheets:


Cash book

A B C
1 6/9/08 Sale 2000
2 6/15/08 Purch -1000
3 6/4/08 Transf -500

Bank Statement

A B C D
1 001 6/9/08 CAN 2000
2 002 6/15/08 US -1000
3 003 6/4/08 EUR -500
4 004 6/31/08 US 2000

In this example I would like to match columns A & C in the cash book with B
& D in the bank statement and highlight all similiar items thus leaving the
4th row in the bank statement unhighlighted. I would appreciate any
suggestions. Please keep in mind that I am only an average excel user. Thanks
in advance.




--
ACCAguy