Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
Highlight the debit and Credit ( positive and negative) numbers within a column
(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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a column of numbers, some positive, some negative. | Excel Worksheet Functions | |||
I have a column of numbers, some negative, some positive | Excel Worksheet Functions | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
How do I change a column of 500 numbers from positive to negative | Excel Discussion (Misc queries) | |||
Highlight the debit and Credit ( positive and negative) numbers within a column | Excel Programming |