Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight the debit and Credit ( positive and negative) numbers within a column
"David McRitchie" wrote in message ...
Hi Sandip, When you indicate highlight do you really need the background to be highlighted, if so then the Conditional Formatting solutions already provided simplify this. http://www.mvps.org/dmcritchie/excel/condfmt.htm But if you just want to more conventionally change the FONT color then you can use normal cell formatting. #,##0.00_);[Red](#,##0.00) Since you have numbers and not converting between text and numbers the change of format is immediate. http://www.mvps.org/dmcritchie/excel...tFormatExample By the way the newsgroup microsoft.public.excel.worksheetfunctions was changed years ago on the Microsoft newsservers to microsoft.public.excel.worksheet.functions the old one hangs around in UseNet. Those of us that attach directly to the Microsoft newsservers would never see your posting except for the fact that you cross-posted. (cross-posting is not a good practice). --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Sandip Shah" wrote... 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. David, I have gone through the website on conditional formatting. I had also gone through CPearsons website prior to posting this message. The problem I see in conditional formatting is that it highlights the duplicate entry but not the orginal entry. For eg. If I have 4500 on row 1 and -4500 on row 12, I would want both these numbers to be highlighted so that I can verify it and remove it from the list. Hence in a column which has hundreds of positive and negative numbers, the end result of all the highlighted numbers would be zero since the positive is matched with a negative number. Let me know if I am wrong in my understanding about conditional formatting. Regards Sandip |
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 | |||
Highlight the debit and Credit ( positive and negative) numbers within a column | Excel Programming | |||
Highlight the debit and Credit ( positive and negative) numbers within a column | Excel Programming |