Custom number formatting in Excel

This project received 72 bids from talented freelancers with an average bid price of €4 EUR / hour.

Get free quotes for a project like this
Project Budget
€2 - €6 EUR / hour
Total Bids
Project Description

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 Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online