Stuart

How many +/- matches do you expect to find in these 2 columns?
What if there's more than 1 pair, do you want them different colours?

There may well be two rows containing 34.28 and only one containing
-34.28. I dont know how you can factor this in to the equation.

You have to tell us how to factor this in to equation, these are your
numbers not ours and we can't decide what to do in this instance.

Mike

"Stuart" wrote:

Hello

I hope someone can assist me on this one.

I was hoping it would be fairly easy for someone to write a macro
which can look down a column U and find a positive number and then
match this against a negative number of the same amount.

Basically there should always be a positive and negative number.
Where there is a match with say 34.28 and -34.28 then both rows should
be highlighted.

I want to basically find the rows where there is only either a
positive number or a negative number with no match to the other side.

There may well be two rows containing 34.28 and only one containing
-34.28. I dont know how you can factor this in to the equation.

Sorry if this is a rather complex bit of code.......

Stuart