Formating cells to display negative percentages in red fon...

F

Fast fred

How can I format cells to display negative percentages in red font?
Negative numbers can be displayed in red. Can this be done also for
percentages>
 
M

MarkN

Try typing this into the Format, Cells, Custom box: 0.00%;[Red]-0.00%
Hope this helps
 
F

Fast fred

Worked very well.
Thanks, Mark

MarkN said:
Try typing this into the Format, Cells, Custom box: 0.00%;[Red]-0.00%
Hope this helps
--
MarkN


Fast fred said:
How can I format cells to display negative percentages in red font?
Negative numbers can be displayed in red. Can this be done also for
percentages>
Click to expand...
Click to expand...
 

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

Add "+" plus symbol for a positive percentage 4
Negative percentage in data verification dropdown list? 3
Custom cell format for percentage 3
formatting negative numbers 1
Showing negative values for formula results in red 5
Conditional Format Negative to Postiive Numbers w/3 Symbol Icon Se 2
How do I show negative percentage in a fomula? 1
Using minus values in conditional formatting 1

Top