Need help with highlighting duplicates

[Ibrahim-DH]

Good Morning Guys

I need help with a sheet am working on that has three monthes of intercompany transactions. I need a formula that would help me to highlight a debit or a credit amount that doesnt have a match as you can see in this pic

I tried using the conditional formatting but it didnt work because if there are three $1000 figures in debit and five $1000 figures in credit then it tells me that there is no problem and they all get highlighted !!..
what i need is to math the three identical values and highlight the two lift.

i hope i explained myself well..and hope this could work
Regards

 

[littleiitin]

Hi Ibrahim,

Wecome to the board.

Your attached picture is not visible.

Either attach another or describe your problem in detail.

 

[Ibrahim-DH]

I can see the pic, here is the URL..

http://www8.0zz0.com/2011/07/17/06/172440190.png

Anyway the picture is just a snapshot of the columns..<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
In detail <o></o>
<o></o>
i have two columns Debit and Credit and there are nearly 1000 rows. I want Excel to highlight any credit cell that doesn’t have a match in the debit column and vice versa.<o></o>
<o></o>
When I tried highlighting duplicates in conditional formatting excel didn’t match between the two columns..So it would highlight five cells as duplicates, three of them in debit and two in credit<o></o>
<o></o>
What I want to happen is highlight the four values (two on each column) and keep the odd non high lighted<o></o>

 

[littleiitin]

I have Kept Data in F and G Column for first cell of G i Set the Conditional formatting using this formula:

=ISNUMBER(MATCH(G2,$F$2:$F$125,0))

 

[Ibrahim-DH]

can you tell me exactly what this formula will do?
and can i do this Simultaneously, i mean matching column F with G and G with F at the same formula?

 

[littleiitin]

Actually this formula is checking the occurance of Vale in Cell F2 in whole range in Column G. so it will produce True or False.

onceConditional formatting applied in cell G2, just use format painter to fill to whole column G

 

[Ibrahim-DH]

the problem is i am not looking for the occurance rather than the number of occurances..

for example the value in cell F2 exists in column G, but i need to know that for every value in column F is there a match in column G or not.. and when the values are duplicated like there is three $ 1000 figures in F>> is there three $ 1000 figures in G or not