I need to create a custom number formatting in Microsoft Excel to have negative numbers automatically be displayed in red colour.
However, I need to have comma-style formatting, with currency symbol.
The Excel file that is attached to this contest brief shows what I'd like to have.
I need to retain exactly the same formatting, but I need negative numbers to be displayed in red colour.
Also I need another "custom format type" to have the same as above, but instead of displaying a negative '-' sign, it displays the amount in brackets, along with the comma-style, currency symbol, and red text colour.
Thanks and look forward to some good feedback.
Hi, already done. I used a conditional formatting for your purpose. So we can keep the same current format but the cell will be in red if the content have the signal '-'.
I can send you your sample with this format. Just click "discuss the project" so that we can discuss.
Thanks
You work is done! :)
Hello rbonnici :)
I am an VB / Excel Expert. If you see my reviews by navigating to this link
http://www.freelancer.com/users/feedback_1193882.html?period=entire_history&category=0
then you will notice that I have not disappointed ANYONE TILL date. I have done more than 120 projects. In fact my reviews will speak for myself... One thing I can assure you that if you work with me once, you will always work with me for these kind of projects :)
Hope to work with you.
Regards
Sid
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at my feedback to know more about me and my work. Waiting for more details along with positive response. Thanks.
Good day, CONSIDER IT IS DONE. I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting.
Here are the links for my past experiences:
https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html
https://www.freelancer.com/projects/4848189.html
https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html
https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html
https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html
Regards.
Hi there,
I'm expert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me.
Thank you,
FARZANA PINKY.
Hello there.
I'm an advanced Excel user and developer with great professionalism.
I study electronics and computer engineering at Oporto university and I'm looking for work to fill the blanks on my schedule.
I'm experienced with this type of work and can do it for you right away if you award me the project and send me the file with instructions about in which cells you want the formats described.
I would gladly appreciate this opportunity to work with you.
Best regards,
Bruno Martins
- - - -
EDIT
I've read your aditional message and I can provide you that with quality, fast and extremely cheap.
HI,
I got the resolution for you.
I have created step by step methods top show you how to do that.
Please award the project and create a milestone quickly and I will show those steps and later you can release the milestone.
I am ready to show you the process.
I can immediately help u with this.
I'm a vba programmer having 6+yrs of exp. Pls check my portfolio to know my programming skills.
Pls award me the project. Glad to assist you. Looking forward from u. Thanks.
Hello. I have good skills and experience in Excel processing, data processing, data scraping, data entry, link-posting etc. I can do your task very easy. Please contact me for details. Best regards, Leonard
Thanks for your clear instructions. I can do it now. You will be able to copy this format easily to any cell. I will show you how to copy this format in images.
Also, I will send you images to tell you how to do it by your self.
It will be one hour fixed cost . You will pay one hour only.
Hello, Thank you for the Job posting.
With over 11 years of computer experience I could help you. Now I have shifted to freelancing and hence available to work for you.
Excel is my strong point. I have gone through the sample you attached and have understood the work and I can do this easily.
If you have any questions please do ask me.
I look forward to hearing from you and yes I look forward to some good feedback.
I believe in sincere and accurate work delivered on time.
Thank you
Sincerely
Malini
Hey..
nice to meet you.
i'll know what you want exactly
it's use custom formatting number(and i knew exactly the code of formatting)
i can give you example and anything you want me to do
because i'm newbie in here(but not outside there)
i will do it with very very minimal budget.
hope we will have some mutualism in here
thank you