How do I show negative percentage in a fomula?

T

Terri

We are doing a profit/loss spreadsheet. We can set it up to show a positive
or negative dollar value. We also want to use a percentage in the same way.
We want to be able to have the percentage show as a negative (i.e. red and
with brackets) automatically, so that when the inputted values change, the
resulting percentage is black if positive and red if negative. Is this
possible?

If you need me to make this clearer, please let me know. Thank you for any
assistance.
 
R

Rick Rothstein \(MVP - VB\)

I think the following Custom Format will do what you want...

0.00%;[Red](0.00%)

Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Program buttons to create a word document 0
Add "+" plus symbol for a positive percentage 4
Doughnut Chart linked with the slicer in the pivot table 0
Negative percentage in data verification dropdown list? 3
How do I calculate variance percetage if figures are negative 5
Using minus values in conditional formatting 1
Brackets on negative percents. 3
How do I format a column to show a negative percentage in red? 1

Top