About Us

Sandip Shah

(rafeeq) wrote in message . com...
An easy way of doing this is to use Conditional Formating (under
Format menu). Highlight the entire range of numbers and go to
Conditional Formating. Select cell value to be less than 0 and select
the desired formating (eg. change font color to red). This will
dispaly all value less than 0 in red. Hope this helps.

(Sandip Shah) wrote in message . com...
Hi,

I have dowloaded an account details from my accounting package into
excel. The number of transactions runs into over 10000 lines. All the
debits and credits ( positive and negative ) numbers are in the same
column.

Is there a way through a macro or a function where I can highlight one
set of postive and negative number appearing in the list. Thus all the
numbers with the offset entry ( opposite sign ) should be highlighted.

For eg. If 100 is there on one row, and -100 on some other row (same
coloumn), both these numbers should get highlighted. Incase there is
another 100 with no offseting negative entry, it should remain
unhighlighted.

Your help would be appreciated.

Thanks
Sandip

Hi Jo lee,

Thanks for the macro, its great....

Bye
Sandip

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I have a column of numbers, some positive, some negative.	Skip[_2_]	Excel Worksheet Functions	3	March 23rd 11 05:53 PM
I have a column of numbers, some negative, some positive	Skip[_2_]	Excel Worksheet Functions	3	November 19th 09 12:28 AM
Excel, change column of negative numbers to positive numbers?	Nita	New Users to Excel	3	November 27th 07 04:54 AM
How do I change a column of 500 numbers from positive to negative	JKB	Excel Discussion (Misc queries)	2	September 28th 05 04:16 PM
Highlight the debit and Credit ( positive and negative) numbers within a column	Bernie Deitrick[_2_]	Excel Programming	5	August 29th 03 09:01 AM