|Forum Topic||Post Reply Login|
Rate this:(4/5 from 2 votes)
|Good Morning guys|
I wasn’t sure where to post this thread but I need help in excel regarding a sheet am working on. As you can see in the pic.
I have a list of three months inter-company transactions that I want excel to highlight the amounts that don't have a match.
I tried conditional formatting but the problem is when there is two 1000 figures in Debit and one 1000 figure in credit .. conditional formatting tells me there is a match !!
What I need is a formula that would match the figure and highlight those which are extra.
|Posted by Ibrahim-DH on|
|Replies - Displaying 1 to 1 of 1||Order Replies By: Most Recent | Chronological | Highest Rated|
You could try using a conditional formatting formula with the difference between COUNTIF functions of debits and credits of the amount. If there are more or less debits of the same amount with credits then the conditional format could be applied.
Rate this:(3/5 from 1 vote)
|Excel Business Forums Administrator|
|Posted by Excel Helper on|
|Displaying page 1 of 1|
|Find relevant Excel templates and add-ins for Intercompany Reconciliation in the Excel Business Solutions Directory|