Format cell to show negative percent values in red

negative percent in red color

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…