Ad Clicks :Ad Views : Ad Clicks :Ad Views : Ad Clicks :Ad Views : Ad Clicks :Ad Views :
    Excel formulas and tutorials

    Excel formulas and useful tools

    Home / Excel / Formatting / Format cell to show negative percent values in red

    Format cell to show negative percent values in red

    /
    /
    /
    548 Views

    Isn’t it nicer to see negative percent values in red color instead of all black, differentiated only by the brackets or by the (-) sign?!

    The format code pattern to show negative percent in red color

    Select the cells you want to format and click on Format cells… button. On the Number tab write in the Type field the following code:

    #,##0%_);[Red](#,##0%)

    The outcome should look like this:

    negative percent in red color

    Have fun excelling!

     
    • Facebook
    • Twitter
    • Google+
    • Linkedin
    • Pinterest

    Leave a Comment

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    This div height required for enabling the sticky sidebar