How do I display negative percentages into red by a formula

M

Mike H

I'm not aware of any way of doing it with a formula but it can be done with
custom formatting

Format|Cells|Custom

#,##0%;[Red]-#,##0%

Mike
 

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
Resource name inside resource sheet: per person, work per hours per week 0
Returning a value from a range 1
percentage in brackets 2
Percentage of Weight Loss/Gain 4
difference in numbers displayed as a +/- percentage 3
physical percentage formula 1
Copy addition formula of non-consecutive horizontal cells 2

Top