Excel 2007 : Match and colour like amounts between DR and CR

Hello all,

I have a doubt in Excell 2007.

which feature u use to match and colour like amounts between DR and CR in xls. Meaning I need to compare one reference field + DR amount column with reference field + CR, and colour the identical ones.

Please help me resolve this issue.

Thanks and Regards,
Muthu
upmuthukumar@gmail.com

For more information on the above doubts,

We have 4 columns in a sheet.
col 1 some num
col 2 some text
col 3 few nums similar to col1 but in different fields
col 4 some numbers
col 5 should give like values of col 1 and 2, matched with col 3 and 4, in col 5
ie 1 is say Invoice number
3 is also Invoice number
2 is DR
4 is CR
but DR and CR like lines r lying in diff rows
I need to identify like rows of DR amount and CR amount, and put together in next and next rows and find which DR rows r not having corresponding CR rows.

Please give me my doubts.

Thanks and Regards,
Muthu
upmuthukumar@gmail.com