Custom number formatting in Excel

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.

Skills: Excel

See more: custom format number, excel number custom, excel custom, excel custom number format, custom number formatting, excel custom number, excel custom number formatting, microsoft number, custom number format in excel, symbol of red, Excel Formatting, excel colour, number look, microsoft excel 2013, custom currency, excel create custom file, excel forward, forward excel, format excel good, shows excel, excel good format, good format excel, number symbol, forward number, excel custom format inr

About the Employer:
( 8 reviews ) Lija, Malta

Project ID: #5040421

69 freelancers are bidding on average €4/hour for this job


You work is done! :) Hello rbonnici :) I am an VB / Excel Expert. If you see my reviews by navigating to this link the More

€4 EUR / hour
(104 Reviews)

Hi Dear I'm happy to help you on this First I will do it. Then you can check and offer me the job if you are satisfied.. ;-)) Thanks Priyal

€5 EUR / hour
(67 Reviews)

Hi rbonnici, Had a look at the sample file and can take on the task. Please confirm and I shall deliver both the format settings. Regards, Arul

€6 EUR / hour
(73 Reviews)

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.

€5 EUR / hour
(51 Reviews)

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. J More

€6 EUR / hour
(30 Reviews)

I can suggest you an easy option to accomplish the task. Please consider me and reply through PMB to discuss further.

€5 EUR / hour
(60 Reviews)

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 More

€3 EUR / hour
(24 Reviews)

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 posi More

€5 EUR / hour
(13 Reviews)

Hey rbonnici, please get this done in 2 minutes.... thank you... please reply :-)

€2 EUR / hour
(42 Reviews)

Expert Here.. Award project and get solution within 30 minutes. Regards, Microk

€4 EUR / hour
(20 Reviews)

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.

€16 EUR / hour
(11 Reviews)

Please Consider, I can definitely do that job, I already done this and waiting for your permission to submit it . Thanks

€6 EUR / hour
(10 Reviews)

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 link More

€3 EUR / hour
(7 Reviews)

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 More

€13 EUR / hour
(9 Reviews)

Hi, This is Amit from India. Can work on it immediately. have expertise on excel. Lets start. Thanks, Amit

€4 EUR / hour
(1 Review)

Done! Here is the screenshot ------------------------------------------------------------

€6 EUR / hour
(4 Reviews)

Hello, it's such a simple task, that I'm willing to do it for free. Please see my PM for your file with custom formats created.

€2 EUR / hour
(4 Reviews)

Here is your file formatted:

€2 EUR / hour
(5 Reviews)

I finished your task, if you want to see the result see the link. Only need to pay 5EUR.

€5 EUR / hour
(4 Reviews)

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

€4 EUR / hour
(4 Reviews)