Compare Transactions in two Columns

[ezeB1805]

Hi, I know similar questions have been asked. I did search the forums but was unable to find a solution for my particular problem.

Essentially, i want to compare transactions on a CSV exported file from my bank to the Fee paid on my business spreadsheet. The problem is that the CSV file exports negative quantities for credit card charges and my business spread sheet has positive values.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A (from CSV file)[/TD]
[TD]Column B[/TD]
[/TR]
[TR]
[TD]-52.00[/TD]
[TD]65.44[/TD]
[/TR]
[TR]
[TD]-84.77[/TD]
[TD]52.00[/TD]
[/TR]
[TR]
[TD]-65.44[/TD]
[TD]72.00[/TD]
[/TR]
[TR]
[TD]-102.61[/TD]
[TD]102.61[/TD]
[/TR]
</tbody>[/TABLE]
​

I would like to highlight the the values on Column A that do not appear on Column B. To show me the credit card transactions that are not accounted for.

Thank you

 

[Latchmaker]

Assuming you have headers for your Columns.....Select cell A2 then select Conditional Formatting from the Home Ribbon, then select new rule, the last option states, use a formula to determine which cells to format when you select this option there will be a box that opens place this formula into that box =ISNA(VLOOKUP(A2*-1,$B:$B,1,0)) then select the Format button and pick a color that you want the cell to change to if it is not found in Column B by selecting the Fill Tab and then picking a color, then select OK you can use the format painter to copy the format for all of column A ...... A3 should be the color you chose because it does not have a match in column B