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!

Leave a Reply

Your email address will not be published.

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