In B1: =ABS(A1)

copy down then sort by column B

--
__________________________________
HTH

Bob

"Stuart" wrote in message
...
Hi

Thanks for your responses

There are several hundred rows.

The £34.28 could be matching the -£34.28 on the 500th row. The rows
are not in positive and negative order.

They come in any order.

I want to find pairs in the rows.

Does this make sense?

I am sure someone put together a macro a while back but cannot find
the thread.

Sorry to be a pain.

Stuart

They are not in any particular order.

On Feb 26, 10:04 am, "macropod" wrote:
Hi Stuart,

You don't really need a macro if all you want is for the non-matching cell
pairs to be highlighted - all you need is a conditional
format based in the equation:
=$A1+$B1<0
where A1 & B1 represent the addresses of the cell pair being tested.
Simply enter this formula in the conditional format for the
first to be tested, using the 'Formula is' option from the conditions
dropdown and choose an appropriate pattern highlighting
format, then copy this cell and paste over the whole range using
Edit|Paste Special|Format.

--
Cheers
macropod
[MVP - Microsoft Word]



"Stuart" wrote in
...
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- Hide quoted text -

- Show quoted text -