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

G

Guest

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>
 
G

Guest

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

Guest

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

Red cell for negative numbers in Excel 1
Custom cell format for percentage 3
Highlight Five Values With Conditional Formula 1
Negative percentage in data verification dropdown list? 2
automatic font color 2
Colour coding data 3
Access Negative Percentages in Report in Access 2007 0
Excel turning percentages into scientific notation 2

Top