How do I show negative percentage in a fomula?

G

Guest

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

How do I calculate variance percetage if figures are negative 5
How do I format a column to show a negative percentage in red? 1
Custom cell format for percentage 3
COLOR CODING A PROFIT & LOSS SPREADSHEET 1
Percentage Question 1
Chart in Excel 2007- Positive & negative value columns 10
Percentages 2
How do I align numbers in different cells when some are in bracke. 2

Top